with testdata as (
select 1 as a , 1001 as b
union all
select 2 as a , 1002 as b
union all
select 3 as a , 1003 as b
union all
select 3 as a , 1004 as b
)
select a
from testdata
group by a,b
3
3
2
1
;
select a+1
from testdata
group by a,a-10
4
2
3
;
对group by的进一步理解
最新推荐文章于 2024-07-13 10:38:18 发布