There are a method to paging using ANSI SQL only?

Question

I know:

• Firebird: FIRST and SKIP;
• MySQL: LIMIT;
• SQL Server: ROW_NUMBER();

Does someone knows a SQL ANSI way to perform result paging?

Answer 1

See Limit—with offset section on this page: http://troels.arvin.dk/db/rdbms/

BTW, Firebird also supports ROWS clause since version 2.0