Sql如果写成这样就会报错 SELECT client_group as 营销中心,count(0) as 注册用户 FROM xxx where DATEDIFF(created_at,NOW())=-1group by client_group写成这样就不报错 SELECT client_group as a ,count(0) as b FROM xxx where DATEDIFF(created_at,NOW())=-1 group by client_group 在workbench里一点问题没有 |
最佳回答 |
||||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
|
0
|
|
|||
