select *
from (select T1.*, rownum linenum
from (select * from cod_mpos_order) T1
where rownum <= 100) T2
where linenum >= 90
ORACLE分页查询SQL语句
最新推荐文章于 2024-07-11 03:05:56 发布
select *
from (select T1.*, rownum linenum
from (select * from cod_mpos_order) T1
where rownum <= 100) T2
where linenum >= 90