在同一列上选择两个计数 [英] Select with two counts on same column

问题描述

我有两个select查询：

  SELECT MONTH（date）AS month，count（DISTINCT ip）
 FROM table_name WHERE field = 1 GROUP BY month 
  

和

  SELECT MONTH（date）AS month，count（DISTINCT ip）
 FROM table_name WHERE field = 2 GROUP BY month 
  
 p> 
 
 
如何写一个查询来选择 
 
 
  SELECT MONTH（date）AS month，
 count（DISTINCT ip）[for field = 1]，
 count（DISTINCT ip）[for field = 2] 
  
 
 
解决方案
 
  SELECT MONTH （DISTINCT case，当field = 1，然后ip结束时）为f1，
 count（DISTINCT case，当field = 2，然后ip结束时）为f2 
 FROM table_name 
（1,2） 
 GROUP BY month 
  
 
I have two select queries:
SELECT MONTH(date) AS month, count(DISTINCT ip) 
FROM table_name WHERE field = 1 GROUP BY month
and
SELECT MONTH(date) AS month, count(DISTINCT ip) 
FROM table_name WHERE field = 2 GROUP BY month
how can I write one query to select
SELECT MONTH(date) AS month, 
       count(DISTINCT ip) [ for field = 1], 
       count(DISTINCT ip) [ for field = 2]

解决方案
SELECT MONTH(date) AS month, 
       count(DISTINCT case when field = 1 then ip end) as f1,
       count(DISTINCT case when field = 2 then ip end) as f2
FROM table_name 
WHERE field in (1,2)
GROUP BY month


                        
这篇关于在同一列上选择两个计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！