c#查询语句的问题很怪异

[michael1217]

这个是我的程序里的sql查询语句
语句1：
select distinct(intime),crossingname,aspectname,wayname from (select distinct(crossingname),ID,time,intime,aspectname,wayname from ( select distinct(aspectname),ID,time,intime,crossingname,wayname from ( select distinct(wayname),ID,time,intime,crossingname,aspectname from (select * from (select * from (select rownum rn,ID,time,intime,CROSSINGNAME,ASPECTNAME,WAYNAME from sysadmin.tb_statinfo) where rownum<=(1*30)) where rn>=((1-1)*30+1))))) where time > to_date('2010-01-01 00:00:01','yyyy-mm-dd hh24:mi:ss') and time < to_date('2010-11-24 23:59:59','yyyy-mm-dd hh24:mi:ss')
返回的记录条数是2条

语句2：
select distinct(intime),crossingname,aspectname,wayname from (select distinct(crossingname),ID,time,intime,aspectname,wayname from ( select distinct(aspectname),ID,time,intime,crossingname,wayname from ( select distinct(wayname),ID,time,intime,crossingname,aspectname from sysadmin.tb_statinfo))) where time > to_date('2010-01-01 00:00:01','yyyy-mm-dd hh24:mi:ss') and time < to_date('2010-11-24 23:59:59','yyyy-mm-dd hh24:mi:ss')
返回的记录条数是3条

语句2我就把分页删除了得到的就是我想要的结果，但是加上分页就变成语句1返回的结果。请问这是为什么？比较急，在线等！

[zhaojianjun21c]

是不是 where rn>=((1-1)*30+1))怕句引起的！你把+1去掉试下！！！