select col1,col2,col3 from tablename group by col1,col2,col3 having count(*)>1
select distinct col1[,col2...coln] from yTableName
楼上的大哥的语句好像有点问题! 仅列几种方法 SELECT * FROM @T A WHERE (SELECT COUNT(1) FROM @T WHERE TYPE=A.TYPE )>1SELECT * FROM @T A WHERE EXISTS(SELECT 1 FROM @T WHERE ID=A.ID HAVING COUNT(1)>1)SELECT ID FROM @T GROUP BY ID HAVING COUNT(1)>1
仅列几种方法
SELECT *
FROM @T A
WHERE (SELECT COUNT(1) FROM @T WHERE TYPE=A.TYPE )>1SELECT *
FROM @T A
WHERE EXISTS(SELECT 1 FROM @T WHERE ID=A.ID HAVING COUNT(1)>1)SELECT ID
FROM @T
GROUP BY ID
HAVING COUNT(1)>1