Can I use Where Clause like this for my query.. help me [closed]

Closed. This question needs debugging details. It is not currently accepting answers.

Edit the question to include desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem. This will help others answer the question.

Closed 2 years ago.

Improve this question

SELECT DATE(dateissued) AS date
     , SUM(amount) AS total_collection1 
 Where accountcodeid = '44'
     , SUM(amount) AS total_collection2   
 Where accountcodeid = '40'
  FROM payment
 GROUP 
    BY dateissued 
 ORDER 
    BY dateissued DESC 
 LIMIT 10

​x
 
SELECT DATE(dateissued) AS date     , SUM(amount) AS total_collection1  Where accountcodeid = '44'     , SUM(amount) AS total_collection2    Where accountcodeid = '40'  FROM payment GROUP     BY dateissued  ORDER     BY dateissued DESC  LIMIT 10​

Answer

No but

SUM(case when accountcodeid = '44' then amount else 0 end) AS total_collection1

 
SUM(case when accountcodeid = '44' then amount else 0 end) AS total_collection1​

is valid

Advertisement

Answer