原数据格式
row1 | row2 |
---|---|
a | 1 |
a | 1 |
a | 2 |
a | 1 |
b | 1 |
b | 2 |
b | 2 |
c | 1 |
c | 1 |
c | 1 |
c | 3 |
嵌套后数据格式
row1 | row2 | count |
---|---|---|
a | 1 | 3 |
a | 2 | 1 |
b | 1 | 1 |
b | 2 | 2 |
c | 1 | 3 |
c | 3 | 1 |
select t.row1,t.row2 , count(t.row2) from test t order by t.row1,t.row2
原数据格式
row1 | row2 |
---|---|
a | 1 |
a | 1 |
a | 2 |
a | 1 |
b | 1 |
b | 2 |
b | 2 |
c | 1 |
c | 1 |
c | 1 |
c | 3 |
嵌套后数据格式
row1 | row2 | count |
---|---|---|
a | 1 | 3 |
a | 2 | 1 |
b | 1 | 1 |
b | 2 | 2 |
c | 1 | 3 |
c | 3 | 1 |
select t.row1,t.row2 , count(t.row2) from test t order by t.row1,t.row2