Re: rownum

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 07 Jan 2005 09:26:20 +0100
Message-ID: <crlh3d$9d$1@news.BelWue.DE>

db2group88_at_yahoo.com wrote:
> so if i want to do a insert into a new table where data is from another
> table from row 2 to row 10, what should be right query?
>

There is no such thing in SQL, since if you don't order your result set, the order of the rows is indeterminate (until the time of the actual query of course) and subject to change. A newly added row might well come back among the first 10 rows although from your point of view it should be number 50.

Conclusion: Describe your business case as GreyBeard suggested and you might actually get what you need and not just what you ask for.

HTH
Holger Received on Fri Jan 07 2005 - 02:26:20 CST