News
Abstract
Full LIMIT and OFFSET support
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Full LIMIT and OFFSET support
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
15 January 2020
UID
ibm11138258