我也是最近要用到oracle分页 参考了网上给的介绍
这是我用的sql语句 效果很好 仿照这个就可以了
select * from
(
select my_table.* , rownum as myrow from (
select * from h_eqp_alrt h where h.time_stamp
between to_Date('20041116','yyyy/mm/dd hh24:mi:ss')
and to_Date('20041116','yyyy/mm/dd hh24:mi:ss')+1
and EQP_ID like '%' and EQP_TYPE like '%'
and LINE_ID like '%' and ALERT_CODE like '%'
order by TIME_STAMP
) my_table where rownum <=50
)
where myrow >=1
这是我用的sql语句 效果很好 仿照这个就可以了
select * from
(
select my_table.* , rownum as myrow from (
select * from h_eqp_alrt h where h.time_stamp
between to_Date('20041116','yyyy/mm/dd hh24:mi:ss')
and to_Date('20041116','yyyy/mm/dd hh24:mi:ss')+1
and EQP_ID like '%' and EQP_TYPE like '%'
and LINE_ID like '%' and ALERT_CODE like '%'
order by TIME_STAMP
) my_table where rownum <=50
)
where myrow >=1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货