Will this solution give you the top20 salaries in the
table? Or will it give you the first 20 salaries then
order those?
- Arvind Aggarwal <oradba9_at_yahoo.com> wrote:
> select salary from emp where rownum<21 order by
> salary
> desc;
>
> Arvind Aggarwal
>
> --- Aldi Barco <ipal_at_hotmail.com> wrote:
> > Hi List,
> >
> > This question has been discussed so many times.
> > But I dont have the trick now.
> > Could you please send me the trick to select
> top-20
> > salary of scott.employee table ?
> > Thanks.
> >
> > Aldi
> >
>
> > Get Your Private, Free E-mail from MSN Hotmail at
> > http://www.hotmail.com.
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Aldi Barco
> > INET: ipal_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051
> FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
>
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be
> removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Arvind Aggarwal
> INET: oradba9_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Received on Fri Jan 12 2001 - 16:23:56 CST
