有如下表:
a | b | c |
01 | 100 | 1 |
0101 | 100 | 2 |
0101 | 100 | 3 |
010101 | 100 | 4 |
用一条SQL语句得出如下结果(逐级汇总)
a | Sum(b) |
01 | 400 |
0101 | 300 |
010101 | 100 |
select distinct a, (select sum(b) from tname where a like t.a || '%')
from tname t