db-derby-user mailing list archives

Hi,
I want to fetch first 'n' rows from a table of 1000 records.
I have one select query which will result 500 rows.
select * from tablea where info = '---' ;
//500 records..
But I need only n(say 60) records based on user choice.My application is
going to process n records at a time (n value is user choice). In Oracle I
can give rownum=60
then it will fetch only 60 records.
But in derby im search for a way to do this...
--
Thanks
Raghunath N