SQL SERVER 2000資料庫查詢重複記錄的方法

1.尋找表中多餘的重複記錄，重複記錄是根據單個欄位（account）來判斷
select * from myehome where account in (select account  from  myehome  group  by  account  having  count(account) > 1)

ps:myehome表名 account想查重的欄位名 having count 查重函數

2.尋找表中多餘的重複記錄（多個欄位）
select * from  myehome

where account in (select account from myehome group by account,name having count(*) > 1) and name in (select name  from myehome group by account,name having count(*) > 1)
ps:同時查詢account和name都重複的記錄
有兩個以上查重欄位在條件句where後面就需要單獨寫出來，因為in只能是單一條件，按照網上這樣的“where (a.peopleId,a.seq) in  (select peopleId,seq from vitae group by peopleId,seq  having count(*) > 1)”寫法是要出錯的，暫時沒找到其他簡單的寫法。