mysql 查看我的查询输出我需要不同的方式 [英] mysql views my query output i need different manner

问题描述

这是我的查询

Select Count(Case When campaign_pid != 0 Then 1 End) As Email,
  Count(Case When sms_pid != 0 Then 1 End) As Sms,
  Count(Case When survey_pid != 0 Then 1 End) As Survey
From tablename  

<小时>

请帮帮我这是我的查询输出

---

Please help me This is my query output

Email   Sms     Survey    
21     1       4

<小时>

我需要这样的输出

---

i need output like this

 name    value  
 Email   21  
 Sms     1   
 Survey  4

<小时>

请告诉我如何得到像上面的 optput

---

Please tell me how to get like above optput

推荐答案

TRY

SELECT COUNT(Case WHEN campaign_pid != 0 THEN 1 END) AS Email FROM tablename
UNION
SELECT COUNT(Case WHEN sms_pid != 0 THEN 1 END) As Sms FROM tablename
UNION
SELECT COUNT(Case WHEN survey_pid != 0 THEN 1 END) As Survey FROM tablename

参考

这篇关于mysql 查看我的查询输出我需要不同的方式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！