SQL DISTINCT: Examples

SELECT 
    salary
FROM
    employees
ORDER BY salary DESC;

SELECT 
    DISTINCT salary
FROM
    employees
ORDER BY salary DESC;

SELECT
	job_id,
	salary
FROM
	employees
ORDER BY
	job_id,
	salary DESC;

SELECT DISTINCT
	job_id,
	salary
FROM
	employees
ORDER BY
	job_id,
	salary DESC;

SELECT DISTINCT
	phone_number
FROM
	employees;

SELECT * FROM countries;

SELECT * FROM departments;

SELECT * FROM dependents;

SELECT * FROM employees;

SELECT * FROM jobs;

SELECT * FROM locations;

SELECT * FROM regions;

Execute

Clear Beautify Minify

Reload