Hello

Fb 1.5.1

I have a table currently loaded
with 300,000 rows .

//here is the meta

CREATE TABLE FDET (
RNO INTEGER
, EPOCH INTEGER
, MSE DECIMAL ( 18, 10 )
, TRAINTIME TIMESTAMP
)

I would like to have a query which returns
every 1000 row , so the resultset would have
300 records.

The table is sorted on rno desc .

How would the sql look like ?

Thanks
nxciro