SQL MIN: Examples

Examples
Sample Database

#1

SELECT 
    MIN(salary)
FROM
    employees;

#2

SELECT
 employee_id,
 first_name,
 last_name,
 salary
FROM
 employees
WHERE
 salary = (
 SELECT
 MIN(salary)
 FROM
 employees
 );

#3

SELECT
 department_id,
 MIN(salary)
FROM
 employees
GROUP BY
 department_id;

#4

SELECT
 d.department_id,
 department_name,
 MIN(salary)
FROM
 employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
 d.department_id;

#5

SELECT
 d.department_id,
 department_name,
 MIN(salary)
FROM
 employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
 d.department_id
ORDER BY
 MIN(salary);

#6

SELECT
 d.department_id,
 department_name,
 MIN(salary)
FROM
 employees e
INNER JOIN departments d ON d.department_id = e.department_id
GROUP BY
 e.department_id
HAVING
 MIN(salary) < 3000;

Table List