Re: HELP !!!!

This will only work assuming that the table you are querying from is in the order you require.

Try

select field_name
from table_name t1
where 100 >
  ( select count(*) from table_name t2
    where t1.key_field < t2.key_field);

Mark

Daniel A. Morgan wrote in message <37828D88.E667499B_at_exesolutions.com>...
>> I want the 100 first record of a SQL request with Oracle 8.0.5 with VB5
W95
>> TOP don't work !
>> How can i do ????
>
>select field_name
>from table_name
>where rownum < 101;
>
>Daniel A. Morgan
>
Received on Wed Jul 07 1999 - 10:31:17 CEST