立即学习:https://edu.csdn.net/course/play/27328/370700?utm_source=blogtoedu
#distinct 语法
SELECT DISTINCT column_name1,column_name2 FROM table_name;
只有column_name1和column_name2都一样时,才会被认为是重复数据。
group by也可用于去重:
select column_name from table_name gruop by column_name;