select * from tb_baobiao_info order by TSFTIME desc
select * from tb_baobiao_info order by TSFTIME desc
int cpage=1; //当前页 int ipage=5; //分页单位 int spage; //开始页 //判断起始页 spage=(cpage-1)*ipage; zbsql ="select * from (select bbjc,style,status,tsftime,rownum as my_rownum from tb_baobiao_info where rownum <="+pages*ipage+") where my_rownum>"+spage+""; 这是个分页查询的 只是查询出来了 怎么根据时间倒序查询出来~~
zbsql ="select * from (select bbjc,style,status,tsftime,rownum as my_rownum from tb_baobiao_info where rownum <="+pages*ipage+" ORDER BY TSFTIME DESC) where my_rownum>"+spage+"";
zbsql ="select * from (select bbjc,style,status,tsftime,rownum as my_rownum from (select * from tb_baobiao_info order by tsftime desc) where rownum <="+pages*ipage+") where my_rownum>"+spage+"";
from tb_baobiao_info
order by TSFTIME desc
int ipage=5; //分页单位
int spage; //开始页
//判断起始页
spage=(cpage-1)*ipage; zbsql ="select * from (select bbjc,style,status,tsftime,rownum as my_rownum from tb_baobiao_info where rownum <="+pages*ipage+") where my_rownum>"+spage+"";
这是个分页查询的 只是查询出来了 怎么根据时间倒序查询出来~~
zbsql ="select * from (select bbjc,style,status,tsftime,rownum as my_rownum from (select * from tb_baobiao_info order by tsftime desc) where rownum <="+pages*ipage+") where my_rownum>"+spage+"";