I need to select the middel 50 rows from a table with 21 000 rows.

IE when a person presses next 20 search results in MS SQL 7 I use a temp table

are there #temp tables in Interbase 6 and can you create temp tables in Stored procedures ans select from them.