w3resource
SQL exercises

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


Sample Solution:

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;

Sample Output:

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

Practice Online


HR database model

Query Visualization:

Duration:

Query visualization of Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182 - Duration

Rows:

Query visualization of Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182 - Rows

Cost:

Query visualization of Display the first and last name and salary for those employees who earn less than the employee earn whose number is 182 - Cost

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?



New Content: Composer: Dependency manager for PHP, R Programming