Subject Re: [firebird-support] How do I limit an SQL search list to 10 records?
Author Marcin Bury
Post date 2019-12-12T19:18:36Z
Hi

SELECT FIRST 10 * FROM A_TABLE

Should work

Cheers
Marcin


------ Wiadomość oryginalna ------
Od: "Clyde Eisenbeis cte677@... [firebird-support]" <firebird-support@yahoogroups.com>
Data: 12.12.2019 19:59:44
Temat: [firebird-support] How do I limit an SQL search list to 10 records?

This finds all records:
``````````````````````````````````
    "SELECT * FROM " + stTableName
``````````````````````````````````
This does not work:

``````````````````````````````````
    "SELECT * FROM " + stTableName + " FETCH 10 ROWS"
``````````````````````````````````