select * from (select a.*,row_number(order by 时间字段 desc) as NO) c where c<=10
select * from (select a.*,row_number(order by 时间字段 desc) as NO) c where c.NO <=10
不好意思,刚才漏了. select * from (select a.*,row_number(order by 时间字段 desc) as NO from tb) c where c.NO <=10 也可以这样: Select * From (Select Rownum As No,a.* From tb a Order By 时间字段Desc) c Where c.No<=10
select * from (select a.*,row_number(order by 时间字段 desc) as NO from tb) c where c.NO <=10 这样是可以的啊。
--方案一 select * from ( select a.*,row_number() over (order by jiandangshijian desc ) hs from m_dangan a ) where hs<10--方案二 select * from ( select * from m_dangan order by jiandangshijian desc) where rownum<10
select * from ( select * from m_dangan order by jiandangshijian desc) where rownum<10
where c<=10
where c.NO <=10
select * from (select a.*,row_number(order by 时间字段 desc) as NO from tb) c
where c.NO <=10
也可以这样:
Select * From (Select Rownum As No,a.* From tb a Order By 时间字段Desc) c
Where c.No<=10
where c.NO <=10
这样是可以的啊。
--方案一
select * from (
select a.*,row_number() over (order by jiandangshijian desc ) hs
from m_dangan a
) where hs<10--方案二
select * from ( select * from m_dangan order by jiandangshijian desc) where rownum<10