一张dept表怎么取前五个?
------解决方案--------------------
rownum <=5
------解决方案--------------------
需要按照某条件排序不?
不需要,则:
select * from dept where rownum<=5;
需要,则:
select * from (select select t.*, ROWNUM rn from dept order by xxx asc|desc)
where rn<=5
------解决方案--------------------
select * from dept where rowid<6
------解决方案--------------------
- SQL code
select * from dept where rownum <=5;
------解决方案--------------------