如何查询出重复记录？

[easyfly]

如何在一张表中查询出重复的记录呢？
就是表中有两条或两条以上记录相同，其他记录不相同，查询出有重复的记录。

[easyfly]

Thanks!

[pbsql]

select col1,col2,col3... from t group by col1,col2,col3... having count(*)>1

[WangZWang]

select col1,col2,col3....
from table
group by col1,col2,col3....
having count(*)>1

[yuncai]

select * from table a where (select count(*) from table b where a.xx=b.xx)>1

[ORARichard]

select * from table group by * having count(0)>1

把*换成表中的所有字段

[davorsuker39]

select a,b,c,....
from table
group by a,b,c,....
having count(*)>1