select * from video where board_id=2858 and rownum<=13 order by edit_time desc 是这个意思吗?
LS意思是对的,可惜写错了 select * from ( select v.*,rownum rn from video v where board_id=2858 order by edit_time desc ) where rn <=13
SQL:select top 13 from video where board_id=2858 order by edit_time desc ORACEL:select * from ( select v.*,rownum rn from video v where board_id=2858 order by edit_time desc ) A where rn <=13
是这个意思吗?
select * from (
select v.*,rownum rn from video v where board_id=2858 order by edit_time desc
)
where rn <=13
ORACEL:select * from (
select v.*,rownum rn from video v where board_id=2858 order by edit_time desc
) A where rn <=13