SQL JOINS on HR Database: Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182
SQL JOINS on HR Database: Exercise-7 with Solution
7. Write a query in SQL to display the first and last name and salary for those employees who earn less than the employee earn whose number is 182.
Sample table: employees
SELECT E.first_name, E.last_name, E.salary FROM employees E JOIN employees S ON E.salary < S.salary AND S.employee_id = 182;
first_name last_name salary James Landry 2400.00 Steven Markle 2200.00 TJ Olson 2100.00 Ki Gee 2400.00 Hazel Philtanker 2200.00
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a query in SQL to display all departments including those where does not have any employee.
Next: Write a query in SQL to display the first name of all employees including the first name of their manager.
What is the difficulty level of this exercise?