The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.
New to Blogs?
Share your news and views with others. Learn how to:
Matching: scrollable X
SergeRielau Tags: first rows scrollable cursor offset paging limit fetch 2 Comments 132,452 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