ÇóÒ»oracleµÄsqlÓï¾ä

±í ID NUMBER
  1  20
  2  30
  3  50
  4  10
  5  25
  6  80

ÒªÇó²é³önumber×î´óµÄÇ°Èý¸ö¼Ç¼,oracle sqlÓï¾äÔõôдÄØ£¿£¿£¿

---

row_number() over(order by number desc)

---

ÄÜÏêϸµãÂ𣿣¿

---

create table max3
(id number primary key,
number1 number);

insert into max3 values(1,20);
insert into max3 values(2,30);
insert into max3 values(3,50);
insert into max3 values(4,10);
insert into max3 values(5,25);
insert into max3 values(6,80);

select id, number1 from(select a.*,row_number() over(order by number1 desc) rn  from max3 a)
where rn <4;

      ID    NUMBER1
--------- ----------
        6        80
        3        50
        2        30

---

¿ÉÒÔÓ÷ÖÎöº¯Êý
µ«ÕâÀï²»Ó÷ÖÎöº¯ÊýÒ»Ñù¿ÉÒÔ×öµ½
select * from (
  select * from tt order by number desc)
where rownum <=3
Ó÷ÖÎöº¯ÊýµÄ»°
select * from (
  select tt.*,row_number()over(order by number desc)rn from tt)
where rn <=3
·ÖÎöº¯ÊýµÄÓ÷¨Â¥Ö÷²éÏÂÏà¹Ø×ÊÁÏ£¬ÕâÀï²»ºÃ˵Ã÷

---

ÒýÓÃ