| 音量 |
| 解释|
|---|---|---|
| 10 | 在10之前没有音量 | |
| 7 | 0 | 7 | 之前没有更小的音量
| 13 | 2 | 10和7都小于13 |
| 6 | 0 | 13大于6 |
| 4 | 0 | 6大于4 |
| 8 | 2 | 6和4都小于8|
| 7 | 0 | 8大于7 |
| 3 | 0 | 7大于3|
| 4 | 1 | 3小于4 |
t = table(1..10 as volume) tmp = select volume, iif(deltas(volume)>0, rowNo(volume), NULL) as flag from t tmp.bfill!() select volume, cumrank(volume) from tmp context by flag