Re: Select multiple records with ORDER BY
From: Chris Durgasingh <CDURG.JAREDSYS_at_worldnet.att.net>
Date: 1997/03/15
Message-ID: <5ge7hj$fn4_at_mtinsc05.worldnet.att.net>#1/1
Date: 1997/03/15
Message-ID: <5ge7hj$fn4_at_mtinsc05.worldnet.att.net>#1/1
Joseph Jao <jjao_at_idt.net> wrote:
>It am trying to select multiple records from a table that is to be
>sorted first. I have trouble coming up with a SQL command that selects
>3 names in a company that earn the top salaries. If I say
>
>"select name, sal from emp where rownum <4 order by sal desc;",
>
>it only gives me the first 3 names without sorting. Can anyone share
>his wisdom with me?
Real simple dude! Why are you using 'rownum <4' ? Think about it. Good Luck! Received on Sat Mar 15 1997 - 00:00:00 CET