w3resource

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

Employee Model  Database - w3resource online SQLite practice

Structure of 'hr' database :

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.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook