Go Premium for a chance to win a PS4. Enter to Win
select (select count(something) FROM table1 where value ='33') as A,
(select count(something) FROM table1 where value ='44') as B
Open in new window
COUNT(CASE WHEN Value = '33' THEN 1 ELSE NULL END) AS A,
COUNT(CASE WHEN Value = '44' THEN 1 ELSE NULL END) AS B
select sum(a.A) as 'A'
, sum(a.B) as 'B'
from (Select count(yourColumn) as 'A'
, 0 as 'B'
where value = '33'
, Count(yourColumn) as 'B'
where value = '44'
) as a
Author Closing Comment
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!