with Tags: scrollable X
DB2 has had the FETCH FIRST n ROWS ( FFnR ) clause for many years. FFnR is one of those tricky features that does actually exactly what it claims to do - surprise! A simple test: CREATE TABLE emp(name VARCHAR(10), salary INTEGER); INSERT INTO emp VALUES ...
from Blog: SQL Tips for DB2 LUW