查找數據表中重複的紀錄?

[orcale]

如題,我想把table1重複記錄撈出來有什麼辦法?效率最好??

[pengdali]

select 所有列 from 表 group by 所有列 having sum(1)>1

[yujohny]

select * from biao group by(所有字段) having count(*)>1

[txlicenhe]

select f1,f2,f3 from yourTable
group by f1,f2,f3
having sum(1) > 1

-- 假设按f1,f2,f3三个字段相同就认为重复。

[sdhdy]

select * from 表 group by 所有列 having sum(1)>1

[ghtghtmalone]

select * from biao group by(所有字段) having count(*)>1