Write a query to display the current salary for each employee in department 300. Assume that only

Question:

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 (Figure P7.48).

Figure P7.48 Current Salary for Employees in Department 300 Emp_Num Emp_LName Emp_FName Sal_Amount 83746

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: