how to find duplicate records in sqlserver databases

Hi
i am running a sql server7.0 and front end program in visual basic .. i have around 30,000 records in my database i need to find the duplicate records in my datatbase and have to elliminate them.is there any way i can do this witha query??.Urgent help required ..
thanks in advance..
Selva

Comments

  • : Hi
    : i am running a sql server7.0 and front end program in visual basic .. i have around 30,000 records in my database i need to find the duplicate records in my datatbase and have to elliminate them.is there any way i can do this witha query??.Urgent help required ..
    : thanks in advance..
    : Selva
    :

    Say your key field is X_ID
    select X_ID from tbl
    group by X_ID
    having count(*)>1
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion