hi to all
i want to display duplicate records using single sql query

Love having good sql query

visit google.com and in the search box type ur question.

have a nice day

HI,

Well one way is to group records on the basis of all the columns on tables OR the coulnms on which you consider the row as duplicate.

if Table1 has col1,col2,col3,col4,col5 then u can use :-


Select Count(*) as [count],col1,col2,col3,col4,col5 from Table1
group by col1,col2,col3,col4,col5
having count(*)>1

Please be aware that if u have a large number of columns, its heavy to use.

But if u consider a row duplicate on the basis of col1,col2 then
this will server ur purpose.

Select Count(*) as [count],col1,col2
group by col1,col2having count(*)>1

Hope this helps.

B. Anant