Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> top 21 salary

top 21 salary

From: Sam P. Roberts (ZADCO ITIS) <roberts_at_zadco.co.ae>
Date: Sat, 13 Jan 2001 09:43:41 +0400
Message-Id: <10739.126609@fatcity.com>


select salary from emp where rownum<21 order by salary

desc;  

This is incorrect , will only get first 21 rows Received on Fri Jan 12 2001 - 23:43:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US