Unanswered: SQL script to start search from a row number and next n number of records
I am working on a product which has to support multiple databases.
(Oracle, DB2, Sybase and PostGres). I am using hibernate package which provides multiple database connectivity. My requirement is that
I should write a SQL Query (select statement) which should start from a record number and should return me the next n number of records from that record. The constraint is that i cannot have the primary key to be a index of the record number and i dont have the option of having another column "index" in the table. Could you please get back if it can be done using sql as it has to support all the four mentioned databases.
Thank you in advance.