SELECT * FROM ( SELECT SELECT_EXT_SQL.* , ceil(rownum/10) page FROM (
XXXX(SQL语句)
) SELECT_EXT_SQL ) WHERE page= 1
Oracle分页写法
最新推荐文章于 2024-08-19 08:45:16 发布
SELECT * FROM ( SELECT SELECT_EXT_SQL.* , ceil(rownum/10) page FROM (
XXXX(SQL语句)
) SELECT_EXT_SQL ) WHERE page= 1