Question

I want to fetch 2 coulmns count and do their total as a new column. How can I do this?

i 撰写了这一问询,但这完全是错的。

SELECT count(case when `status`= 1  then 1 else 0 end) AS HOT,
count(case when `status`= 5  then 1 end) 
AS Special_Case,count(case when 1=1 then 1 end) AS TOTAL 
FROM `tbl_customer_conversation` group by 
date(`dt_added`),user_id

Answer 1

COUNT将只提供与记录相符的时间,在你的询问中,记录总是会回来。 1. 导言由于这些数值可以是1或0。 www.un.org/Depts/DGACM/index_french.htm

AS, you want the total number of HOT cases and SPECIAL_CASE you have to use SUM.

SELECT 
    SUM(case when `status`= 1  then 1 else 0 end) AS HOT,
    SUM(case when `status`= 5  then 1 end) AS Special_Case,
    SUM(case when `status` =  1  or `status` =  5  then 1 end) AS TOTAL 
FROM `tbl_customer_conversation` 
group by date(`dt_added`),user_id

友情链接