SELECT * FROM ( SELECT SELECT_EXT_SQL.* , ceil(rownum/10) page FROM (
XXXX(SQL语句)
) SELECT_EXT_SQL ) WHERE page= 1
Oracle分页写法
最新推荐文章于 2023-12-17 13:06:18 发布
SELECT * FROM ( SELECT SELECT_EXT_SQL.* , ceil(rownum/10) page FROM (
XXXX(SQL语句)
) SELECT_EXT_SQL ) WHERE page= 1