请教一个 Group By 的问题
SQL语句如下
select DATE_FORMAT(date,"%Y-%m") AS `record_date`, SUM(activated) as activated from `users_log` where `date` between '2021-01-02' and '2021-07-26' group by `record_date`
当我把
select DATE_FORMAT(date,"%Y-%m") AS `record_date`
改写成
select DATE_FORMAT(date,"%Y-%m") AS `date`
这个SQL语句就失效了,这是为什么? AS
不能写同名字段吗? 如果我一定要写同名字段应该要怎么做呢?谢谢
推荐文章: