IBM Support

Full LIMIT and OFFSET support

News


Abstract

Full LIMIT and OFFSET support

Content

Look in the SQL Reference for complete details:

OFFSET
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzoffset.htm
FETCH FIRST N ROWS ONLY (aka LIMIT)
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzfetchfirst.htm

Figure 1. Overview

image-20200115131458-1

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
15 January 2020

UID

ibm11138258