Re: NEWBIE: Limit Rows Returned by Select ?

select * from system_history
WHERE ROWNUM<=1000
order by primary_key desc

or use more meaningfull criteria like
WHERE employeenr < 12345 or
WHERE UPPER(CITY) = 'AMSTERDAM'
or whatever

Arie Mars
arie_at_pca-online.nl

Steve Cholerton <stevechol_at_freeuk.com> schreef in berichtnieuws fgaptss9ej6ipq414mv2svj87t9dfrguq8_at_4ax.com...
> Hi all
> Can anybody advise me if there is a way to limit the number of rows
> returned by a select statement, I have a select statement alsong the
> following lines:
>
> select * from system_history order by primary_key desc
>
> I only want the last thousand rows ... is this possible ?
> Many thanx
> -Steve
Received on Fri Oct 06 2000 - 03:01:23 CDT