| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL selecting records
include the following where clause (rownum) in your query:
select *
from table
where <your_own_criteria>
and rownum < 5 -- add this line
Alain.
Alan wrote:
> I am trying to only get the first 5 records out of tables that met certain
> criteria. Can I get these 5 records without getting all the records that
> met certain criteria? Thanks.
Received on Tue Feb 13 2001 - 14:41:42 CST
 |
 |