Posted by Roy Harvey on 07/25/06 12:05

If your table does not have Rownumber, then neither does SQL Server.
Relational tables do not have order, there is no first row, or fourth
row, no next and no prior.

If you can not write a SELECT that returns just the rows you want
deleted, they you will not be able to write a DELETE that will remove
that set of rows.

Roy Harvey
Beacon Falls, CT

On 25 Jul 2006 05:00:49 -0700, "surya" <suryaitha@gmail.com> wrote:

>hi all
> i hava eetable that is ,
> eename sal
>_______ ________
> suresh 100000
> ramsesh 100000
> raja 100000
>susjssj 100000
> dkddkd 100000
>jfdjfdjfd 100000
>
>so i want to delete from second to Fourth row by using Rownumber
>.Rownumber is not a column of eetable give some example

• Next in forum: sp_who and Citrix
• Prev in forum: delete particular rows in a table
• Thread view: Re: delete particular rows in a table

[Reply to this message]