应用实例:对数组下标的变更
范例01:
| A | B | C | D
|
|---|---|---|---|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
| 0 | 1 | 2 | 3
|
|---|---|---|---|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
| 0 | 0 | 0 | 0
|
范例02:使用聚集函数时-对多列操作时的命名
| A | B | C
|
|---|---|---|
| 0 | 10 | 20
|
| 1 | 11 | 21
|
| 2 | 12 | 22
|
| 3 | 13 | 23
|
| 4 | 14 | 24
|
| 5 | 15 | 25
|
| A | B | C
|
|---|---|---|
| 0 | 10 | 20
|
| 1 | 21 | 41
|
| 3 | 33 | 63
|
| 6 | 46 | 86
|
| 10 | 60 | 110
|
| 15 | 75 | 135
|