相当于LIMIT for DB2

作者: 狗头军师
发布时间: 2024-03-18 12:26:13 (4月前)

2 条回复

1#
回复此人
v-star*위위 | 2020-08-07 14-12

使用FETCH FIRST [n] ROWS ONLY： http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.perf/db2z_fetchfirstnrows.htm ``` SELECT LASTNAME, FIRSTNAME, EMPNO, SALARY FROM EMP ORDER BY SALARY DESC FETCH FIRST 20 ROWS ONLY; ``` 要获得范围，您必须使用ROW_NUMBER()（自v5r4起）并在WHERE子句中使用它：（从此处偷来：http : //www.justskins.com/forums/db2-select-how-to-123209.html ） ``` SELECT code, name, address FROM ( SELECT row_number() OVER ( ORDER BY code ) AS rid, code, name, address FROM contacts WHERE name LIKE '%Bob%' ) AS t WHERE t.rid BETWEEN 20 AND 25; ```

编辑

登录后才能参与评论