Re: [firebird-support] How do I limit an SQL search list to 10 records?

['Marcin Bury' marcin.b...@studio-delfi.pl [firebird-support]]

Hi

SELECT FIRST 10 * FROM A_TABLE
Should work

Cheers
Marcin


------ Wiadomość oryginalna ------
Od: "Clyde Eisenbeis cte...@gmail.com [firebird-support]" 
<firebird-support@yahoogroups.com>
Do: 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"
``````````````````````````````````