Duplicate Records SQL 1

[DVFS]

What is a quick SQL query to simply show me a list of duplicate records that exist in a database?

 

[mrees]

This would suggest that your tables do not have primary keys, or do you mean duplicate records when ignoring the primary key?

 

[DVFS]

Duplicate records ignoring primary keys. Sorry.

 

[TheGreenOne]

This should work, I can't say how quick it will be without knowing how many records are in the table.

select * from tablename
where colname in(
	select colname from (
		select colname, cnt=count(*)
		from tablename
		group by colname) as subqry
	where cnt > 1)

 

[kishleo]

select col1,col2,col2.... from table
groupby col1,col2,col3....
having count(*) > 1

Kishore MCDBA

 

[DVFS]

Both samples worked great, I appreciate the help.

 

[DWMaster]

well i was looking for this query, thanks it was so simple