select substr(col_name,1,4) as year, substr(col_name,5,2) as month, substr(col_name,7,2) as day, sum(XXX) -- 你要的聚集函数汇总字段(可以有N多个这样的字段) from tb_name group by substr(col_name,1,4), substr(col_name,5,2), substr(col_name,7,2);
学习。select substr(col_name,1,4) as year, substr(col_name,5,2) as month, substr(col_name,7,2) as day, sum(XXX) -- 你要的聚集函数汇总字段(可以有N多个这样的字段) from tb_name group by substr(col_name,1,4), substr(col_name,5,2), substr(col_name,7,2); 问一楼红色部分的一定要写出来吗啊?
select substr(trim(col),1,6) 年月, substr(trim(col),5,2) 月, substr(trim(col),7,2) 日, sum(col2) from tb group by substr(trim(col),1,6),substr(trim(col),7,8)
--这个 select substr(trim(col),1,6) 年月, substr(trim(col),5,2) 月, substr(trim(col),7,2) 日, sum(col2) from tb group by substr(trim(col),1,6),substr(trim(col),5,2),substr(trim(col),7,2)
substr(col_name,5,2) as month,
substr(col_name,7,2) as day,
sum(XXX) -- 你要的聚集函数汇总字段(可以有N多个这样的字段)
from tb_name
group by substr(col_name,1,4),
substr(col_name,5,2),
substr(col_name,7,2);
substr(col_name,5,2) as month,
substr(col_name,7,2) as day, sum(XXX) -- 你要的聚集函数汇总字段(可以有N多个这样的字段)
from tb_name
group by substr(col_name,1,4),
substr(col_name,5,2),
substr(col_name,7,2);
问一楼红色部分的一定要写出来吗啊?
select substr(trim(col),1,6) 年月,
substr(trim(col),5,2) 月,
substr(trim(col),7,2) 日,
sum(col2)
from tb
group by substr(trim(col),1,6),substr(trim(col),7,8)
--这个
select substr(trim(col),1,6) 年月,
substr(trim(col),5,2) 月,
substr(trim(col),7,2) 日,
sum(col2)
from tb
group by substr(trim(col),1,6),substr(trim(col),5,2),substr(trim(col),7,2)