Re: SQL - SELECT x rows...

I don't think that works because the ROWNUM is done before the sorting, so you won't always get the same recordset back.

You need to use TOP-N Optimization to do it becuase it allows sorting prior to row number selection.

"R.Schulenberg" <Raphaela.Schulenberg_at_t-online.de> wrote in message news:8ms6uv$74i$18$1_at_news.t-online.com...
> Try it with .....where rownum <21 or <101
> - but this will only work when you set 'order by' in a way that the
> required records will be the first ones to be shown -
>
> Rgds Raphaela
>
> "Joseph Ranseth" <jransethNO_SPAM_at_worldcupfishing.com> schrieb im
> Newsbeitrag news:BKgk5.14$Lc.1764_at_news1.mts.net...
> > How can I select 'x' number of rows from/in a query?
> >
> > ie: I want to select the 20 oldest employees, or 100 highest paid, etc.
> >
> > Is there a simple way of going about this, or do I have to select all of
 the
> > records and then only print the desired amount (That wouldn't be
 efficient,
> > though, would it?)
> >
> > Thanks in Advance,
> >
> > JR
> >
> >
Received on Wed Aug 09 2000 - 00:00:00 CDT