SQLite Exercise: Find the names, the salary of the employees who earn the same salary as the minimum salary for all departments

Write a query to find the names (first_name, last_name), the salary of the employees who earn the same salary as the minimum salary for all departments.

Sample table : employees

SQLite Code:

SELECT * FROM employees 
WHERE salary = (SELECT MIN(salary) FROM employees);

Output:

employee_id  first_name  last_name   email       phone_number  hire_date   job_id      salary      commission_pct  manager_id  department_id
-----------  ----------  ----------  ----------  ------------  ----------  ----------  ----------  --------------  ----------  -------------
132          TJ          Olson       TJOLSON     650.124.8234  7/19/1987   ST_CLERK    2100                        121         50

Practice SQLite Online

Model Database

Structure of 'hr' database :

Improve this sample solution and post your code through Disqus.

Previous: Write a query to find the names (first_name, last_name), the salary of the employees who earn more than Mr. Bell.
Next: Write a query to find the names (first_name, last_name) of the employees who are not supervisors.