
以上是我的表结构,select ifnull(sum(if(name like '%登录' and type = '1',1,0)),0) as '1',
ifnull(sum(if(name like '%登录' and type = '2',1,0)),0) as '2',
ifnull(sum(if(name like '%登录' and type = '3',1,0)),0) as '3',
ifnull(sum(if(name = '绑定手机号' and type = '1',1,0)),0) as '4',
ifnull(sum(if(name = '绑定手机号' and type = '2',1,0)),0) as '5',
ifnull(sum(if(name = '绑定手机号' and type = '3',1,0)),0) as '6',
ifnull(sum(if(name = '自己申请入职' and type = '1',1,0)),0) as '7',
ifnull(sum(if(name = '自己申请入职' and type = '2',1,0)),0) as '8',
ifnull(sum(if(name = '自己申请入职' and type = '3',1,0)),0) as '9' from t_rpt_service_access_m where 1=1
这是我的sql语句。
现在我登录查出来的是登录的次数,而我想要去重我表中 的uuid这个字段,查出我登录的人数,下面绑定手机还有自己申请入职需要查出所有的,修改我的sql语句应该怎么写。