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