Posted by --CELKO-- on 07/26/06 15:20

>> want to delete from second to Fourth row by using Rownumber. Rownumber is not a column of eetable give some example <<

Let's get back to the basics of an RDBMS. Rows are not records; fields
are not columns; tables are not files; there is no sequential access or
ordering in an RDBMS, so "first", "next" and "last" are totally
meaningless. If you want an ordering, then you need to have a column
that defines that ordering. You must use an ORDER BY clause on a
cursor or in an OVER() clause.

You have missed the whole point of RDBMS!!

[Back to original message]