DanBrother的部落格

/* Top 10 Analysis Using Rank() Over */

-- 建立測試資料表:
create table rank_over_test
(id varchar2(12),
 point number(10)
) pctfree 10 pctused 75;

-- 寫入測試資料
declare
v_id varchar2(12) default null;
v_point number(10) default 0;
begin
   for i in 1..20 loop
       v_id:='test'||lpad(i,3,0);
       v_point:=trunc(dbms_random.value(1,10000));
       insert into rank_over_test(id,point)
       values(v_id,v_point);
  end loop;
commit;
end;
/

-- 測試資料列表:
select * from rank_over_test;