20. Write a query to display the current salary for each employee in department

Question

20. Write a query to display the current salary for each employee in department 300. Assume that only current
employees are kept in the system, and therefore the most current salary for each employee is the entry in the
salary history with a NULL end date. Sort the output in descending order by salary amount

The book is Database Systems Design, Implementation, & 11th Edition pg 404

Please use the syntax for access to solve this problem.

The database is  sale original database--largeCo.mdb

http://www.cengage.com/cgi-wadsworth/course_products_wp.pl?fid=M20b&product_isbn_issn=9781285196145&token=

Explanation / Answer

Select emp_no, emp_name, salary_amt from employee join sal_hist using(emp_no) where sal_end is NULL and dep_num = 300 order by salary_amt desc;

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.