SQL: How to find Duplicate values in a large table

Question

I have a table of about 2 million SKU's. Is there a way to detect any sku that occurs more than once by running a select query??

codingbadger · Accepted Answer · 2011-01-06 17:23:36Z

7

Select SKU
From table
Group By SKU
Having Count(SKU) > 1

answered Jan 6, 2011 at 17:23

codingbadger

44.3k13 gold badges99 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Larry Lustig · Accepted Answer · 2011-01-06 17:23:52Z

2

 SELECT SKUColumn, COUNT(*) FROM YourTable
    GROUP BY SKUColumn HAVING COUNT(*) > 1

answered Jan 6, 2011 at 17:23

Larry Lustig

51.2k16 gold badges119 silver badges173 bronze badges

shankhan · Accepted Answer · 2011-01-06 17:24:44Z

0

select SKU, count(SKU) cnt from table group by SKU having cnt > 1

answered Jan 6, 2011 at 17:24

shankhan

6,5812 gold badges22 silver badges22 bronze badges

It will take an awful long time to look through that result set. . .

@Larry: agreed forgot to add having clause