Subject Re: [firebird-support] Restricting the amount of returned rows
Author Hannes Streicher
Guten Tag Pasi Parkkinen,

am Dienstag, 20. Januar 2009 um 12:17 schrieben Sie:


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

select FIRST x skip y



--
Mit freundlichen GrĂ¼ssen
Hannes Streicher mailto:HStreicher@...