pl/sqlÎÊÌâ

Ò»ÕÅdept±íÔõôȡǰÎå¸ö£¿

---

rownum <=5

---

ÐèÒª°´ÕÕijÌõ¼þÅÅÐò²»£¿

²»ÐèÒª£¬Ôò£º
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

---

´ò´íÁË rownum

---

ÒýÓÃ

ÐèÒª£¬Ôò£º
select * from (select select t.*, ROWNUM rn from dept order by xxx asc|desc)
where rn <=5

ÕâÖÖÈ¡Ç°5λÊÇÓÐÎÊÌâµÄ£¬ÒªÔÙ¼ÓÒ»²ãǶÌ×,ÒòΪrownum ÅÅÐò±Èorder by ÏÈ×ö
select * from (select t.*,rownum rn from (select select * from dept order by xxx asc|desc) t)
where rn <=5

---

ÒýÓÃ

SQL codeselect*from deptwhere rownum<=5;

---

ÒýÓÃ

ÒýÓà 2 Â¥ suiziguo µÄ»Ø¸´:ÐèÒª£¬Ôò£º select * from (select select t.*, ROWNUM rn from dept order by xxx asc|desc) where rn <=5

ÕâÖÖÈ¡Ç°5λÊÇÓÐÎÊÌâµÄ£¬ÒªÔÙ¼ÓÒ»²ãǶÌ×,ÒòΪrownum ÅÅÐò±Èorder by ÏÈ×ö
select * from (select t.*,rownum rn from (select select * from dept order by xxx asc|desc) t)
where rn <=5

Nice£¡
ллָ½Ì£¡

---

ÒýÓÃ

ÒýÓà 2 Â¥ suiziguo µÄ»Ø¸´:ÐèÒª£¬Ôò£º select * from (select select t.*, ROWNUM rn from dept order by xxx asc|desc) where rn <=5

ÕâÖÖÈ¡Ç°5λÊÇÓÐÎÊÌâµÄ£¬ÒªÔÙ¼ÓÒ»²ãǶÌ×,ÒòΪrownum ÅÅÐò±Èorder by ÏÈ×ö
select * from (se