- 利用 DISTINCT 关键字来消除重复记录的基本语法如下所示
SELECT DISTINCT column1, column2,.....columnN
FROM table_name
WHERE [condition]
- 利用 GROUP BY 语句
SELECT column1, column2
FROM table_name
WHERE [ conditions ]
GROUP BY column1, column2
ORDER BY column1, column2