select * from (
select rownum rownums, t.* from t_journal t where rownum <=20 order by id desc
) where rownums >=10
该语句是查询t_journal 表,第10行到20行数据。
select rownum rownums, t.* from t_journal t where rownum <=20 order by id desc
) where rownums >=10
该语句是查询t_journal 表,第10行到20行数据。