不明白第二个语句为什么要那样写?
这样写结果一样啊,不见得比你的慢
SELECT rownum,TRAVEL_ID,TRAVEL_NO,TRAVEL_DES,TRAVEL_AFF_ID,TRAVEL_DT4,TRAVEL_USER1_ID
FROM (select * from t_travel order by TRAVEL_DT4 desc) where travel_loc='deal_finish' and rownum<=$pagesize and rownum>$offset
这样写结果一样啊,不见得比你的慢
SELECT rownum,TRAVEL_ID,TRAVEL_NO,TRAVEL_DES,TRAVEL_AFF_ID,TRAVEL_DT4,TRAVEL_USER1_ID
FROM (select * from t_travel order by TRAVEL_DT4 desc) where travel_loc='deal_finish' and rownum<=$pagesize and rownum>$offset
(select rownum as rid ,TRAVEL_ID ,TRAVEL_NO ,TRAVEL_DES ,TRAVEL_AFF_ID ,TRAVEL_DT4 ,TRAVEL_USER1_ID from (select * from t_travel where travel_loc='deal_finish' order by TRAVEL_DT4 desc) where rownum <=$pagesize )where rid >$offset ;
直接使用 rownum >= a and rownum <= b 这样是取不到纪录的
rownum 不是真实的列,只是一个伪列