oracle over,partition,rank,rank_number
@over 함수over함수는 order by , group by, subQuery를 개선하기 위해 나온 함수이다. create table test100(a varchar2(10),b varchar2(10) ); //테이블생성 INSERT INTO test100 VALUES ('2','516958');INSERT INTO test100 VALUES ('1','123458');INSERT INTO test100 VALUES ('1','458512');INSERT INTO test100 VALUES ('2','468521');INSERT INTO test100 VALUES ('2','735196');INSERT INTO test100 VALUES ('1','794528');INSERT INTO test100 ..
2015. 10. 13.
