DISTINCT 语法
1 SELECT DISTINCT NAME FROM TABLENAME
删除去重SQL语法
DELETE FROM QuestionLib where ID in ( select min(ID) ID FROM QuestionLib group by NAME having Count(0)>1);
DISTINCT 语法
1 SELECT DISTINCT NAME FROM TABLENAME
删除去重SQL语法
DELETE FROM QuestionLib where ID in ( select min(ID) ID FROM QuestionLib group by NAME having Count(0)>1);
转载于:https://www.cnblogs.com/vstarks/p/4970937.html