Matching: scrollable X
SergeRielau Tags: scrollable limit rows first offset fetch cursor paging 2 Comments 41,664 Views
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