firebird - How to limit number of records in Dynamic SQL -
i want execute select query return limited number of records in dynamic sql firebird database server.
similar 1 in sql of mssql
select top 10 * table;
p.s., using interbase 6.0 database firebird 2.5 odbc driver.
you can't interbase 6.0 doesn't have feature. first n skip m
added in firebird 1.0, , rows m n
added in firebird 2.0. use firebird 2.5 odbc driver(*) irrelevant: can use features offered interbase 6.
interbase 6 +/- 15 years old. should consider upgrading, either firebird 2.5 or recent version of interbase.
(*): there no firebird 2.5 odbc driver, latest version of firebird odbc driver 2.0.2
Comments
Post a Comment