数据库分页查询脚本

1. 分页样例：

select * from (select *, rownum as rn from (select * from test order by id) )where rn>1 and rn<20 --oracle 或 dm

select * from (select * from test order by id) t limit 1,20 ---dm 或 mysql

2.查询最新的一条记录

        select * from test order by createtime limit 1;