Re: sql limitation?

The point is that I think Emmanuel needs to think a little more on the problem. The query below (while syntactically correct) doesn't really mean anything in the sense that what does the 10th row really mean in an unordered set? Unless he just wants the 10th row and he is satisfied that it can be random. That might be okay in certain statistic sampling problems.
Jim
"Steve" <stevemc_at_sierra.com> wrote in message news:9s9ueu$4en$1_at_spiney.sierra.com...
> here are some hints:
>
> use nested queries
> use rownum
> use order by
>
> "outer most" query:
>
> select <blah>
> from (subqueries which produce rownum as my_rownum)
> where my_rownum = 10
>
>
> "Fabre" <Emmanuel.Fabre_at_tangensys.com> wrote in message
> news: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 Nov 07 2001 - 06:19:26 CET