Hi Peter,

   Thanks. Sorry for posting here. I tried this but still getting the duplicates.

Thanks

San.

Hi peter,

   Thanks for the reply. I amusing Sql Server 2000. Any help would be greatly appreciated.

Thanks

San.

Hi Anders,

   Thanks for the reply. I cannot use a cursor or Stored Proc and I dont have access rights to create a TEMP table. I need a Sql which...

Like SELECT TOP(PART_ID)

Thanks

San.

Any suggestion would be greatly apprecited.

Thanks

San.

Hi PW,

   Thanks for the reply. But I have 2 records with the same PART_ID and I want one record with the unique PART_ID.

Any help would be greatly appreciated.

Thanks

San.

Thanks PW and Mark.

PW's remarks:

The columns whose values are in green represent the "primary key", but there are cases of duplicates. Correct ?

The columns PART_ID DATE PART_CD  REN_CD are...

It does not matter which row to keep and which row to avoid. I just need the record out of the dups.

Thanks

San.

Any SUggestions how to accomplish this.

Thanks

San.

Nope. Its not working that way. Thanks

San.

 I need all the columns. My data is something like this.

PART_ID   DATE       PART_CD  REN_CD   STATE BN_NO BN_CD  BN_DS  DESC   ID

206544    2006-01-01 DDD      11       TX    45789 TIN    OTHER  NULL   500

206544    2006-01-01...

Thanks John. I need to provide the data with the unique EMPID and hence need to remove the dups. The DB design is correct as far as our app is...

Thansk for the reply John.

EMPID   ENAME   ROLE   SAL  COMMENTS MGRID MGRNAME GROUP OTHER

PK defined on EMPID,ENAME,ROLE,SAL.

Let me know.

Thanks

San

I have a PK defined on four columns. I need to eliminate the dups and get the first dup row so forth and so on for some other purpose. Hope...