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

Home -> Community -> Usenet -> c.d.o.misc -> Simple SQL Question

Simple SQL Question

From: Paulo Odulio <r40890_at_email.sps.mot.com>
Date: Sat, 11 Apr 1998 11:11:07 +0800
Message-ID: <352EDF4B.5782278C@email.sps.mot.com>

What shall I add to the where clause to be able to get only the first 3 records?

select ename, sal
from emp
where <condition>
order by sal desc;

Thanks,
-Paulo


Received on Fri Apr 10 1998 - 22:11:07 CDT

Original text of this message

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