解决方案 »
- mysql存储过程里面游标二重循环如何做,有思路么,可以实现吗?
- mysql中如何使用extra查看索引
- mysql存储过程问题
- 求解,关于单用户登陆的问题
- 自编辑中值函数median,mysql中报错Can't open shared library
- 请问不能用函数设置表的初始时间么create table f (birthday datetime not null default concat(current_date(),' ',current_time()));
- mysql怎么老装不上啊?
- 为什么用控台mysql -e命令执行sql语句不会记入binlog
- mysql统计不为null的列总数问题
- 求助一个查询语句!
- mysql_query返回1
- mysql_query返回1
t3.manager,
max(case t1.cust_type when '01' then t1.cust_typeC else 0 End) a,
max(case t1.cust_type when '02' then t1.cust_typeC else 0 End) b,
max(case t1.cust_type when '03' then t1.cust_typeC else 0 End) c,
max(case t2.cust_belong when '01' then t2.cust_belongC else 0 End) d,
max(case t2.cust_belong when '02' then t2.cust_belongC else 0 End) e,
max(case t2.cust_belong when '03' then t2.cust_belongC else 0 End) x
from
(select m.manager , m.cust_type , count(1) cust_typeC from b_customer_base_info_t m group by m.manager , m.cust_type) t1,
(select m.manager , m.cust_belong , count(1) cust_belongC from b_customer_base_info_t m group by m.manager ,m.cust_belong) t2,
(select m.manager from b_customer_base_info_t m group by m.manager ) t3
where t3.manager = t1.manager
and t3.manager = t2.manager
group by t3.manager