lundi 20 juillet 2015

SQLITE Query the same table twice and put these queries into two different columns?

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