结果:
actor_id | cnt | rank | dummy |
107 | 42 | 1 | 42 |
102 | 41 | 2 | 41 |
198 | 40 | 3 | 40 |
181 | 39 | 4 | 39 |
23 | 37 | 5 | 37 |
81 | 36 | 6 | 36 |
106 | 35 | 7 | 35 |
158 | 35 | 7 | 35 |
13 | 35 | 7 | 35 |
37 | 35 | 7 | 35 |
结果:
actor_id | cnt | rank |
107 | 42 | 1 |
102 | 41 | 2 |
198 | 40 | 3 |
181 | 39 | 4 |
23 | 37 | 5 |
81 | 36 | 6 |
158 | 35 | 7 |
13 | 35 | 7 |
37 | 35 | 7 |
144 | 35 | 7 |
结果:
actor_id | cnt | rank |
107 | 42 | 1 |
102 | 41 | 2 |
198 | 40 | 3 |
181 | 39 | 4 |
23 | 37 | 5 |
81 | 36 | 6 |
158 | 35 | 7 |
13 | 35 | 8 |
37 | 35 | 9 |
144 | 35 | 10 |
结果:
actor_id | first_name | rownum |
132 | ADAM | 1 |
71 | ADAM | 2 |
165 | AL | 3 |
173 | ALAN | 4 |
146 | ALBERT | 5 |