SURESHKUMAR.NET FORUMS - View Single Post

jsangeetha · 08-04-06, 05:53 AM

Hi Krishna

SELECT A,B,C,D, count(*)
FROM MyTable
GROUP BY A,B,C,D
HAVING count(*) > 1

This query should help you identify the duplicate rows. This would group all the records with the values of columns A,B,C and D and then count the no. of rows in that group. If the Count is more than1 then its a duplicate.

Hope this helps.

Sangeetha

Edited by: jsangeetha

08-04-06, 05:53 AM	#2 (permalink)
jsangeetha Senior Member Join Date: Apr 2006 Location: Posts: 151 Thanks: 0 Thanked 9 Times in 5 Posts Rep Power: 5	Hi Krishna SELECT A,B,C,D, count() FROM MyTable GROUP BY A,B,C,D HAVING count() > 1 This query should help you identify the duplicate rows. This would group all the records with the values of columns A,B,C and D and then count the no. of rows in that group. If the Count is more than1 then its a duplicate. Hope this helps. Sangeetha Edited by: jsangeetha
Offline