ORACLE中取出表中按照某字段排序的前N条记录。
除了用类似select * from (select * from TestSort order by ID) where rownum <=3;这种方法以外还有别的方法吗?
除了用类似select * from (select * from TestSort order by ID) where rownum <=3;这种方法以外还有别的方法吗?
from (
select l.*,row_number() over(order by id) rn
from like_test l
)
where rn <= 3;
应该可以的。
除了用类似select * from (select * from TestSort order by ID) where rownum <=3;这种方法以外还有别的方法吗?select top N * from testsort order by yourcolumn
那好象是SQL SERVER的吧?