SEO

#1 (**permalink**) 02-29-2008, 06:32 AM

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 ......

#2 (**permalink**) 02-29-2008, 06:32 AM

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

#3 (**permalink**) 02-29-2008, 06:32 AM

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 ......

#4 (**permalink**) 02-29-2008, 06:32 AM

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

#5 (**permalink**) 02-29-2008, 06:36 AM

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 ......

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode