[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 125
  • Last Modified:

SQL statement ... mutliple queries with on result set

I want to do something like this

select count(something) FROM table1 where value ='33'
select count(something) FROM table1 where value ='44'

and want it returned as on result set like this

A        B
32      67
0
vbnetcoder
Asked:
vbnetcoder
1 Solution
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
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

0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
SELECT  
    COUNT(CASE WHEN Value = '33' THEN 1 ELSE NULL END) AS A, 
    COUNT(CASE WHEN Value = '44' THEN 1 ELSE NULL END) AS B 
FROM Table1

Open in new window

0
 
Koen Van WielinkIT ConsultantCommented:
It would help if you can post some sample data for us to work with. But one possible solution:

select sum(a.A) as 'A'
, sum(a.B) as 'B'
from (Select count(yourColumn) as 'A'
                      , 0 as 'B'
          from yourTable
          where value = '33'

          union all

          select 0
                     , Count(yourColumn) as 'B'
          from yourTable
          where value = '44'
          ) as a

Open in new window


This would work for 2 or 3 different columns. Anything more than that and it becomes unmanageable. If what you're looking for is more complex, we'll need some sample data to work with.
0
 
Scott PletcherSenior DBACommented:
You can get all totals from the same table in a single pass of the table:

SELECT
    SUM(CASE WHEN value = '33' THEN 1 ELSE 0 END) AS count_33,
    SUM(CASE WHEN value = '44' THEN 1 ELSE 0 END) AS count_44
FROM table1
WHERE
    value IN ('33', '44')
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now