主页 / 问题 / 729258
Accepted
Пупкин_Василий
Asked:2020-10-11 12:11:21 +0000 UTC2020-10-11 12:11:21 +0000 UTC

MySQL 使用一张表中的计数连接表并进行分组

  • 772

下午好！有一个表需要从两个请求中提取数据。然后把它们放在一起。redir_num 是在两种情况下都存在的值。但是加入不起作用:(

select redir_num, count(*) as "Bad" from vks where (call_result = 8 and date(dt_tm)=curdate()) group by redir_num as t1
join
select redir_num, count(*) as "Good" from vks where (call_result = 10 and date(dt_tm)=curdate()) group by redir_num as t2
on t1.redir_num=t2.redir_num;
mysql

2 个回答

  1. Best Answer
    SELECT redir_num
     , SUM(call_result =  8 AND DATE(dt_tm)=CURDATE()) AS Bad
     , SUM(call_result = 10 AND DATE(dt_tm)=CURDATE()) AS Good
FROM vks
GROUP BY redir_num;
    • 0

  2. 你好。试试这样：

    SELECT redir_num
 , SUM(case when call_result =  8 AND DATE(dt_tm)=CURDATE() then 1 else 0 end) AS Bad
 , SUM(case when call_result = 10 AND DATE(dt_tm)=CURDATE() then 1 else 0 end) AS Good
FROM vks
GROUP BY redir_num
    • 0

相关问题