Re: How to extract "nn" row from a table

Hai
try the below one
select * from table1
where rownum <= (select count(*)-(count(*)-10) from table1) /

Wishes
Suresh

Jean-Gwilherm Praud wrote:

> Hello,
>
> I Have to extract just the 10 first results row of my sql query !
> how can I do simply.
>
> Thank.
Received on Thu Jun 04 1998 - 02:05:15 CDT