开发是个漫长的积累过程,储备从现在开始,呵呵
select * from table where ID in(select min(ID) from table group by field)
field为不重复内容字段
查某字段 重复的记录
select ID from tabName group by ID having count(ID)>1
开发是个漫长的积累过程,储备从现在开始,呵呵
select * from table where ID in(select min(ID) from table group by field)
field为不重复内容字段
查某字段 重复的记录
select ID from tabName group by ID having count(ID)>1