Using MySQL DISTINCT to Eliminate Duplicates: Examples

Back Home

SELECT 
    lastname
FROM
    employees
ORDER BY lastname;

SELECT DISTINCT
    lastname
FROM
    employees
ORDER BY lastname;

SELECT DISTINCT
    state
FROM
    customers;

SELECT DISTINCT
    state, city
FROM
    customers
WHERE
    state IS NOT NULL
ORDER BY state , city;

SELECT 
    state, city
FROM
    customers
WHERE
    state IS NOT NULL
ORDER BY state , city;

SELECT 
    state
FROM
    customers
GROUP BY state;

SELECT DISTINCT
    state
FROM
    customers;

SELECT DISTINCT
    state
FROM
    customers
ORDER BY state;

SELECT 
    COUNT(DISTINCT state)
FROM
    customers
WHERE
    country = 'USA';

SELECT DISTINCT
    state
FROM
    customers
WHERE
    state IS NOT NULL
LIMIT 5;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;

Execute

Clear Beautify Minify