select 所有列 from table group by 所有列 having count(*)>1
我这样理解对吗? 如tab1(fie1,fie2) 现在找出fie1有重复记录的条数select * from ( SELECT Count(*) AS mycount,fie1,fie2 FROM tab1 GROUP BY tab1.fie1 ) as mytab where mytab.mycount>1最近在这个栏目问了很多题目 感觉有几个靓仔很厉害 如大力,还有偶很菜,小马哥,monkey,所以班门弄斧了 :)
如tab1(fie1,fie2)
现在找出fie1有重复记录的条数select * from
(
SELECT Count(*) AS mycount,fie1,fie2
FROM tab1
GROUP BY tab1.fie1
) as mytab
where mytab.mycount>1最近在这个栏目问了很多题目 感觉有几个靓仔很厉害 如大力,还有偶很菜,小马哥,monkey,所以班门弄斧了 :)