SELECT DISTINCT 移除結果集中重複的資料列,回傳唯一值組合。
SELECT DISTINCT column1, column2 FROM table_name;
+----+----------+-----------+--------------+----------+
| Id | LastName | FirstName | Address | City |
+----+----------+-----------+--------------+----------+
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes |
| 2 | Svendson | Tove | Borgvn 23 | Sandnes |
| 3 | Pettersen| Kari | Storgt 20 | Stavanger|
+----+----------+-----------+--------------+----------+
SELECT DISTINCT City FROM Persons;
+-----------+
| City |
+-----------+
| Sandnes |
| Stavanger |
+-----------+
SELECT DISTINCT City, LastName FROM Persons;
以 (City, LastName) 組合判斷唯一性。
DISTINCT 會觸發排序或雜湊去重,大資料量較慢。GROUP BY 替代 (語意不同但結果常相同):SELECT City FROM Persons GROUP BY City;COUNT(DISTINCT col)。