Hi All,

Let me give my problem description in detail.

I use SQL server 2000.

I have a table 'TAB' with 3 coulumns 'Name','Age','Sex'

and there is no primary key.

I have multiple duplicate data in my table. for eg..

ABC24M

ABC24M

LMN27M

LMN27M

LMN27M

PQRS25F

XYZ24M

XYZ25M

Now i would wish to 'DELETE' the 1st original row ( Row no 1,3,6,7)

and keep the other duplcates from above data. 😎

Now, If there is a row without any dupicates present.. it will be deleted ( for eg Row no 6)

The condition is i dont want to go for intermediate tables or have any

additional identity column. :w00t:

Please help..!!

Thanks folks