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