Hi
SELECT FIRST 10 * FROM A_TABLE
Should work
Cheers
Marcin
------ Wiadomość oryginalna ------
Od: "Clyde Eisenbeis [email protected] [firebird-support]"
<[email protected]>
Do: [email protected]
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"
``````````````````````````````````
