how can i run a sql query that can count rows and set them as different variables depending on the value

Asked Jul 18 '16 at 07:53

Active Jul 18 '16 at 07:53

Viewed 33 times

I am trying to create a variable that counts the number of occurrences in a row and sets them as a variable, depending on the particular value of 'action_type'

SELECT COUNT(v.visits_id) visits,s.source_type source,COUNT(CASE WHEN a.action_type=2) sale,COUNT(CASE WHEN a.action_type=1) contact FROM visits v 
    JOIN sources s ON v.source_id=s.source_id 
    JOIN actions a ON a.source_id=s.source_id
    GROUP BY source ORDER BY visits DESC

So in this scenario I would want to be creating two variables for each row called sale and contact, which would have counted the occurrences when action_type=1 or action_type=2

How is this achieved?

asked Jul 18 '16 at 07:53

Jack Queen

Do you mean **column**? I can't see any variables created. – KaeL Jul 18 '16 at 07:57
yes sorry of course – Jack Queen Jul 18 '16 at 08:08
Okay, what you need is conditional count (that's the term I used to search). I will have to flag this as duplicate. – KaeL Jul 18 '16 at 08:26
Possible duplicate of [Conditional Count on a field](http://stackoverflow.com/questions/1288058/conditional-count-on-a-field) – KaeL Jul 18 '16 at 08:26

how can i run a sql query that can count rows and set them as different variables depending on the value

0 Answers0