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 P8.20)

 

Transcribed Image Text:

FIGURE P8.20 CURRENT SALARY FOR EMPLOYEES IN DEPARTMENT 300 Emg Nam Emp LName Emp FName SI Amount E3745 RANKIN SEAN 94090 5920 8530 79540 75200 78650 B4328 CARPENTER FERN B37 16 RIVERA HENRY MERLE B4432 JAMISON E3302 VARGAS ROCKY 83535 MENDEI CARROLL B4S00 WESTON CHRISTINE BE34 TIDWELL ODELL 76110 72240 72000 E910 AVERY LAUREN B399 WATTS MERLE ES790 ACEVEDO LAVINA FIGURE P8.20 CURRENT SALARY FOR EMPLOYEES IN DEPARTMENT 300 Emg Nam Emp LName Emp FName SI Amount E3745 RANKIN SEAN 94090 5920 8530 79540 75200 78650 B4328 CARPENTER FERN B37 16 RIVERA HENRY MERLE B4432 JAMISON E3302 VARGAS ROCKY 83535 MENDEI CARROLL B4S00 WESTON CHRISTINE BE34 TIDWELL ODELL 76110 72240 72000 E910 AVERY LAUREN B399 WATTS MERLE ES790 ACEVEDO LAVINA

Answer rating: 100% (QA)

select DISTINCT EmpNu... View the full answer