Restrict number of rows retrieved in Ingres select query
ingres, sql
Solution
You can use the OFFSET clause in the following way:
SELECT col_name
FROM table
WHERE col_name = 'value'
OFFSET m FETCH FIRST n ROWS ONLY
For example
SELECT *
FROM table
OFFSET 501 FETCH FIRST 500 ROWS ONLY
Problem
I want to know if there is a way to select a subsequent bunch of rows in select query in Ingres. For example, the first 500 rows can be selected by using the select first 500 from tablename, but if I want to select rows 501 to 1000, is there any way to do that?