Answer to Question #280610 in Databases | SQL | Oracle | MS Access for sql_guy

Question

/*7. Show any employee who is not a manager, but earns more than any manager in

the employees table. Show first name, last name, job id, and salary. Sort the result 

by salary.*/

What are some ways of writing is query?

Answer 1

SELECT employee.*
FROM your_table_name AS employee
JOIN your_table_name AS manager ON manager.EMPNO = employee.MGR 
WHERE employee.SAL > manager.SAL