Posted by Roy Harvey on 07/26/06 15:25

Somehow I knew you were going to say that.


On 26 Jul 2006 08:20:27 -0700, "--CELKO--" <jcelko212@earthlink.net>
wrote:

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