分页问题！！

77woshi

select * from (select * from (select sms_interface_bak.*,rownum num from sms_interface_bak where to_char(sys_time,'yyyy-mm-dd') between '2006-06-01' and '2006-06-29' order by sys_time desc)sms_interface_bak where rownum<=54) sms_interface_bak where num>=36

“where num>=36 ”这一句不起作用，请问该如何解决？

77woshi

没人知道吗？

77woshi

都没人在线吗？

jametong

sms_interface_bak
where rownum<=54

应该是这个限制将所有的where num>=36 数据都过滤掉了吧..

应该这样写sql吧..
select *
from (
        select *
        from (
                select sms_interface_bak.*,rownum num
                from sms_interface_bak
                where to_char(sys_time,'yyyy-mm-dd') between '2006-06-01' and '2006-06-29'
                order by sys_time desc
        )
        sms_interface_bak
        where rownum<=54
) sms_interface_bak
where rownum>=36

里面的那个rownum num是没有什么实际意义的..

77woshi

照你这样写的话，排序就不起作用了

77woshi

select * from (select sms_interface_bak.*,rownum num from sms_interface_bak where to_char(sys_time,'yyyy-mm-dd') between '2006-05-30' and '2006-06-01' order by sys_time desc)sms_interface_bak where num<=18 and num>=0

这样排序就不对了