It will give you the top20 salaries in the table.
Arvind Aggarwal
- james ellis <jellis24_gso_at_yahoo.com> wrote:
> 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!?
> Yahoo! Photos - Share your holiday photos online!
> http://photos.yahoo.com/
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: james ellis
> INET: jellis24_gso_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).
Received on Fri Jan 12 2001 - 17:01:57 CST
