My question is how to do two select statements and have the results in separate colummns?
For Example,
My statements are
Select count(*) as "JAN" from tickets where created_at BETWEEN "2015-01-01" AND "2015-01-31"
Select count(*) as "FEB" from tickets where created_at BETWEEN "2015-02-01" AND "2015-02-25"
I have tried placing a comma and putting the second statements in parenthesis but that hasn't worked either. I am not sure what exactly I am doing wrong. Could anyone take a look at this? Thank you for your time in advance.
Aucun commentaire:
Enregistrer un commentaire