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