版权声明:本文为博主原创文章,未经博主允许不得转载。 https://cloud.tencent.com/developer/article/1433216
sql view plain copy
结果:
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 |
sql view plain copy
结果:
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 |
sql view plain copy
结果:
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 |
sql view plain copy
结果:
actor_id | first_name | rownum |
---|---|---|
132 | ADAM | 1 |
71 | ADAM | 2 |
165 | AL | 3 |
173 | ALAN | 4 |
146 | ALBERT | 5 |