Select multiple records with ORDER BY
From: Joseph Jao <jjao_at_idt.net>
Date: 1997/03/11
Message-ID: <33261BBE.4BD1_at_idt.net>#1/1
Date: 1997/03/11
Message-ID: <33261BBE.4BD1_at_idt.net>#1/1
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?