- 论坛徽章:
- 0
|
本帖最后由 yoron 于 2010-04-20 17:25 编辑
SQL> select * from test;
A1 A2 A3
---------- ---------- ----------
tom china male
jim usa male
lily usa female
lucy usa female
jerry china male
SQL>select A1,A2,count(A2)over(partition by A2) from test order by count(A2)over(partition by A2);
A1 A2 COUNT(A2)OVER(PARTITIONBYA2)
---------- ---------- ----------------------------
jerry china 2
tom china 2
jim usa 3
lily usa 3
lucy usa 3
SQL> select A1,A2 from test order by count(A2)over(partition by A2) ;
A1 A2
---------- ----------
jerry china
tom china
jim usa
lily usa
lucy usa
SQL> select A1,A2 from test order by count(A2)over(partition by A2) desc;
A1 A2
---------- ----------
lucy usa
jim usa
lily usa
jerry china
tom china
学习........ |
|