Faster way to find out duplication of records in the table

Asked Mar 11 '13 at 12:43

Active Mar 11 '13 at 12:44

Viewed 138 times

I have to find out all the duplicate records in an table. i could get it done by using the following query

SELECT column4
FROM Table1
GROUP BY column1,column2,column3
HAVING COUNT(*) > 1

but while the table contain huge records the group by is becoming very slow. is there any faster way to do it...?

edited Mar 11 '13 at 12:44

MarcinJuraszek

asked Mar 11 '13 at 12:43

Saif

2

Is this MySQL or SQL Server? – steoleary Mar 11 '13 at 12:48
4

This query does not compile. What are you grouping by and what do you need to get back? Also, which version of SQL Server are you using? – Sebastian Meine Mar 11 '13 at 12:50
I ran this in mysql and its working. i was looking for a query which is compactible in all databases. – Saif Mar 11 '13 at 14:00
How grotesque: the duplicate for this question was found rather quickly... – ppeterka Mar 11 '13 at 14:07
thank you..will look into the duplicates – Saif Mar 13 '13 at 04:02

0 Answers0