MySQL DISTINCT语句

1.SELECT 
    lastname
FROM
    employees
ORDER BY lastname;
ORDER BY : 默认排序

2.SELECT DISTINCT
    lastname
FROM
    employees
ORDER BY lastname;
SELECT DISTINCT : 删除重复

3.SELECT DISTINCT    state, city
FROM
    customers
WHERE
    state IS NOT NULL
ORDER BY state , city;
IS NOT NULL : 值不是NULL