db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raghunath <raghu.na...@gmail.com>
Subject How to get first 'n' rows from table
Date Sun, 27 Jan 2008 18:58:56 GMT

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...

Raghunath N

View raw message