我现在有一个Oracle的分页SQL语句,现在因为项目需要改成DB2的分页SQL
Oracle SQL如下:
SELECT RRRRR_. *
FROM (SELECT ROW_. *
, ROWNUM ROWNUM_
FROM (SELECT t. *
, (SELECT className
FROM sys_datadictclass
WHERE classid = t.classid) className
FROM sys_datadict t
WHERE 1 = 1 AND t.classid = '1436512514394305'
ORDER BY classId ASC) ROW_
WHERE ROWNUM <= 20) RRRRR_
真心不会,我改了好多次都没成功,还望各位大哥帮忙,小弟在此万分感谢!
收起