Subject Re: [firebird-support] Getting n number of rows from a table ...
Author Martijn Tonies
Hi,


> Is there any way I can retrieve only n number of rows, and not
> all the rows,
> from a table? Something similar to :
>
> SELECT TOP n * FROM <table> as used in MS Access/SQL Server...

SELECT FIRST n SKIP m * FROM ...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com