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. From the following table, write a SQL query to find those employees who earn less than the employee of ID 182. Return first name, last name and salary.

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

Relational Algebra Expression:

Relational Algebra Tree:

Pictorial Presentation:

Practice Online

Query Visualization:

Duration:

Rows:

Cost:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: From the following table, write a SQL query to find all departments including those without any employee. Return first name, last name, department ID, department name.
Next: From the following table, write a SQL query to find the employees and their managers. Return the first name of the employee and manager.