santosh_stb@indiatimes.com

I have a table in my databse, and there is only one field in the table
and there are 3 rows which are similar and i want to delete the first
row of the 3 row . How cani do it ??????? . Please Help me
out .....Alter Table tableName add Id int identity

Delete from TableName where id in (Select min(id) from TableName group
by FieldName)

Alter table TableName Drop column id

Madhivanan|||Hmm... tricky one...

1. Highlight on the record you want to delete. (Click on the record
selector) .
2. Click on the "Delete" key on your keyboard, or rightclick on the record
and click on "Delete"

That just might do it

<santosh_stb@.indiatimes.com> wrote in message
news:ac643a30.0503090110.54be6cc6@.posting.google.c om...
>I have a table in my databse, and there is only one field in the table
> and there are 3 rows which are similar and i want to delete the first
> row of the 3 row . How cani do it ??????? . Please Help me
> out .....|||1. Highlight on the record you want to delete. (Click on the record
selector) .
2. Click on the "Delete" key on your keyboard, or rightclick on the
record
and click on "Delete"

That just might do it

Rudi,
I think you cant do it as you said. You will get the error too many
rows affected

Madhivanan|||How about delete all three and add 1 back in.

You can copy the three to another table, delete from 1st table, an then
insert from copy using select distinct...

<santosh_stb@.indiatimes.com> wrote in message
news:ac643a30.0503090110.54be6cc6@.posting.google.c om...
> I have a table in my databse, and there is only one field in the table
> and there are 3 rows which are similar and i want to delete the first
> row of the 3 row . How cani do it ??????? . Please Help me
> out .....