在最近项目中，要取出Oracle中获得经过排序的前N条记录，不能用top(N),只能用rownum关键字来实现
select n.*
from (select m.*, rownum rw
from (select T.*
from t_Km_Hotwords t
where t.publish_flag = 'N'
order by t.order_num asc) m) N
where n.rw <= N
select n.*
from (select m.*, rownum rw
from (select T.*
from t_Km_Hotwords t
where t.publish_flag = 'N'
order by t.order_num asc) m) N
where n.rw <= N
扫一扫
129
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
