oracle中时间列如何倒序排序

[genglong1024]

表：tb_baobiao_info
列 BBID(number) ,BBJC(varchar2(50)), TSFTIME(date)

怎么样从数据库根据时间倒序取出所有内容 ？

[genglong1024]

[Quote=引用 4 楼 bearfishshow 的回复:]
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+"";
[/Quote]

还是不行 和没加 效果一样....继续求救

[惊鸿仙子君]

我了个去！

[xiaobn_cn]

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+"";

[areswang]

select * 
from tb_baobiao_info
order by TSFTIME desc

[秋雨飘落]

select * from tb_baobiao_info order by TSFTIME desc

[genglong1024]

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+"";