I have a query that currently reports a result for every record in the table.
I want to limit to limit the query to a specific row#, not primary key#.
How can I do that?
HSQLDB: SELECT LIMIT 10 1 * FROM "MyTable"
Will show the 11ths row only
Might be it works also with Firebird in GUI, but it isn’t original Firebird Code.
Firebird: ROWS 1 TO 10
then the row# is 1 
anywayz, Ask/Guide - How to use the Ask site - The Document Foundation Wiki #Are_there_any_answers_to_my_question_yet
would make sense to follow up on what you query looks like as of now, and what is not understandable 
→ Show row number of records in query result - #4 by cpb