mysql select去重的五种方法
导读：使用DISTINCT关键字 SELECT DISTINCT column_name FROM table_name; 使用GROUP BY子句 SELECT column_name FROM table_name GROUP BY c...
- 使用DISTINCT关键字
SELECT DISTINCT column_name FROM table_name;
- 使用GROUP BY子句
SELECT column_name FROM table_name GROUP BY column_name;
- 使用子查询
SELECT column_name FROM table_name WHERE column_name IN (SELECT DISTINCT column_name FROM table_name);
- 使用HAVING子句
SELECT column_name FROM table_name GROUP BY column_name HAVING COUNT(column_name) = 1;
- 使用临时表
CREATE TEMPORARY TABLE temp_table AS SELECT DISTINCT column_name FROM table_name; SELECT * FROM temp_table;
声明：本文内容由网友自发贡献，本站不承担相应法律责任。对本内容有异议或投诉，请联系2913721942#qq.com核实处理，我们将尽快回复您，谢谢合作！
若转载请注明出处： mysql select去重的五种方法
本文地址： https://pptw.com/jishu/684105.html