DISTINCT删除重复数据

DISTINCT 语法

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);