数据如下
错误写法!
select msisdn as msisdn
,max(no_active_day) as 60002_d_no_active_day_con_max_m6
,min(called_ops_nbr_con) as 60002_d_called_ops_nbr_con_min_m6
from xyxj_test_1221_60002_val where stat_month>=202105 and stat_month<=202110
group by msisdn
;
正确写法!
select msisdn as msisdn
,max(no_active_day) as 60002_d_no_active_day_con_max_m6
,min(cast(called_ops_nbr_con as int)) as 60002_d_called_ops_nbr_con_min_m6
from xyxj_test_1221_60002_val where stat_month>=202105 and stat_month<=202110
group by msisdn
;