有四列:类别,编号,标题,时间。 现在需要以时间排序来取出每个类别里的前五条数据(比如:a类别下时间在前面的五条数据,b类别下时间在前面的五条数据)!谢谢各位了!select * from (select rownum row_num, a.* from tab a order by 时间) where row_num <=5
select * from ( select t.*,row_number() over(partition by 类别 order by 时间) rn from table t) where rn<=5
select * from ( select t.*,row_number() over(partition by 类别 order by 时间) rn from table t) where rn<=5非常谢谢! 也谢谢chanet兄!
现在需要以时间排序来取出每个类别里的前五条数据(比如:a类别下时间在前面的五条数据,b类别下时间在前面的五条数据)!谢谢各位了!select *
from (select rownum row_num, a.*
from tab a
order by 时间)
where row_num <=5
select t.*,row_number() over(partition by 类别 order by 时间) rn
from table t)
where rn<=5
select t.*,row_number() over(partition by 类别 order by 时间) rn
from table t)
where rn<=5非常谢谢!
也谢谢chanet兄!