HI



You can use FIRST/SKIP



Select first 10 skip 100 from table



Or



In FB 2.1 you can use ROWS



SELECT * FROM T2

ORDER BY COL

ROWS 10 TO 100



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Pasi Parkkinen
Sent: Tuesday, January 20, 2009 13:17
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Restricting the amount of returned rows



Hi,

is it possible to restrict the amount of returned rows in your SELECT
statement, where you for example wants to get the first 1000 records. On
other DB products there are ways but I couldn't find one from Firebird...

-Pasi

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]