select count(id) as count_id,media,(select count(id) from customer where will=1 and media=a.media) from customer as a group by media order by count_id desc这个里面有两个SQL语句能不改成一个查询,
比如
select count(id) as count_id,media,count(统计media分组中will=0的条数) from customer as a group by media order by count_id desc
比如
select count(id) as count_id,media,count(统计media分组中will=0的条数) from customer as a group by media order by count_id desc
解决方案 »
- 一个MYSQL的子查询优化的问题
- MYsql触发器问题 搞了一下午没搞明白
- MYSQL的if里面能不有别的语句
- 老出错: mysql Duplicate entry ‘*’ for key 1
- Mysql和postgresql 对数据量到了500万时,性能怎样
- mysql无法完成启动
- mysql水平分区问题
- 求救:APACHE + MYSQL调试两个星期仍然缓慢,上线在即!
- mysql order by uptime desc 之后 CPU 100%
- 08cms7.1每天早上mysql卡爆服务器
- 不知道大家有没有那种比较标准的配置文件~我这个db只作检索想提高检索的效率阿~
- 各位 这个SQl语句应该如何写会更加高效?
sum(if(b.will=1,1,0)) from customer as a
inner join customer b
on b.media=a.mediagroup by a.media order by count_id desc
sum(case when wild=1 then 1 else 0 end)
from customer as a
group by media
order by count_id desc
sum(if(a.will=1,1,0)) from customer as a
group by a.media order by count_id desc