oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éÇ°ÈýÌõ¼Ç¼½µÐò£»

---

select * from
  (select * from table order by col_name desc)
where rownum<=3;

---

select * from
(
select s.*,rownum rn 
from t3 s
)
where rn<=3;

---

ÒýÓÃ

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éÇ°ÈýÌõ¼Ç¼½µÐò£»

select * from tb where rownum <= 3

---

SQL code:

--Óкü¸ÖÖ·½·¨
--1:¼òµ¥
select *
from (select * from your_table order by col desc) a
where rownum < 4;

--2:ÓÃÓÚ·ÖÒ³
select *
from (
select a.*,rownum as rn
from (select * from your_table order by col desc) a
) b
where rn between 1 and 3

---

Â¥Ö÷¼ÇµÃ½áÌù
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html