View previous topic :: View next topic
|
Author |
Message |
Velmurugan_j
New User
Joined: 04 Aug 2005 Posts: 49
|
|
|
|
Can anyone tell me how to fetch
how to fetch the duplicate rows in a table |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
|
|
Duplicate on what... Complete ROW ?????
Primery Key field wont have duplicates....
Regards,
Priyesh. |
|
Back to top |
|
|
bonniem
New User
Joined: 09 Aug 2005 Posts: 67
|
|
|
|
Say for example u want to remove duplicates for col_A,
select col_A, count(*) from table
group by col_A
having count(*) > 1
the same can be used if you want to group by more than one column, say col_a, col_b etc. |
|
Back to top |
|
|
|