sql limitation?
From: Fabre <Emmanuel.Fabre_at_tangensys.com>
Date: 31 Oct 2001 05:01:45 -0800
Message-ID: <55d558a7.0110310501.af61dc7_at_posting.google.com>
Date: 31 Oct 2001 05:01:45 -0800
Message-ID: <55d558a7.0110310501.af61dc7_at_posting.google.com>
Hi,
What is the efficient way to select the 10th row in a table? Let's assume, there is no way to select it directly. At the moment, I do not see how to avoid to select (and fetch depending on the treatment) the first 9 rows. Probably, it makes no sense from an sql point of view?
Thanks in advance,
Emmanuel
Received on Wed Oct 31 2001 - 14:01:45 CET