Homework Help: programing

Posted by kenny on Monday, May 9, 2011 at 5:41pm.

5.Write a query to display the details of employees in the shipping' department who were hired after '01-JAN 1990' note that the query must use a join.

6.Write a query to display all unique department_id's in the employees table.

7.Write a query to display the detail of employees whose names start with 'A' and are in any one of the following departments; 20, 60, 100.

8.Write a query to display the employee last name, email, phone_number, hire_date, and department_name of all employees who earn a commission.

9.Write a query to find the earliest hire_date in each department in the Employees table.

10.Write a query to display the name, salary, department_name and job_title of all employees whose salary is greater than $10.000

programing - SraJMcGin, Monday, May 9, 2011 at 6:53pm
Here are some tutorials to go through:

http://search.yahoo.com/search?fr=mcafee&p=how+to+write+queries+in+programming+tutorials

Sra

Answer this Question

Related Questions

programing - 3.Write a query to display the annual salary of all employees in ...
programming - 1.Write a query to display the names of the employees that do not ...
programing - 10.Write a query to display the name, salary, department_name and ...
Math - Carl hired 4 people to work in his shipping department for a week at 8 ...
math - Carl hired 6 people to work in his shipping department for a week at 12 ...
programing - small startup software developer company needs to create a program...
programing - A small startup software developer company needs to create a ...
Calculus - Write a slope field for the differential equation. Corporate ...
statistics - The purchasing department has suggested that all new computer ...
aiu - Imagine that you have been hired as an IT consultant and have been asked ...

For Further Reading

First Name:
School Subject:
Answer: