SQL 去重方法详解：5种常用技巧

1. 使用'DISTINCT'关键字

SELECT DISTINCT column_name FROM table_name;

2. 使用'GROUP BY'语句

SELECT column_name FROM table_name GROUP BY column_name;

3. 使用子查询

SELECT column_name FROM (SELECT DISTINCT column_name FROM table_name) AS temp_table;

4. 使用'ROW_NUMBER()'函数

SELECT column_name FROM (SELECT ROW_NUMBER() OVER (PARTITION BY column_name ORDER BY column_name) AS row_num, column_name FROM table_name) AS temp_table WHERE row_num = 1;

5. 使用'EXISTS'子查询

SELECT column_name FROM table_name t1 WHERE NOT EXISTS (SELECT 1 FROM table_name t2 WHERE t2.column_name = t1.column_name AND t2.id < t1.id);