Tuesday, December 25, 2012

Multiple COUNT SELECTS from the same table in one query

SELECT sum(case when Page LIKE '%AEC%' then 1 end) as tAEC, 
    sum(case when Page LIKE '%TOL%' then 1 end) as tTOL 
FROM someTable 
http://stackoverflow.com/questions/12938332/multiple-count-selects-from-the-same-table-in-one-query

No comments:

Post a Comment