combining two queries

alexiop · #1 (**permalink**) 07-03-09, 13:02

Hi everybody..

have this first query

select sum(hours) as Sumhours1
where category=1

second query now with category=2

select sum(hours) as Sumhours2
where category=1

Is it possible to combine this query into one

thanks

r937 · #2 (**permalink**) 07-03-09, 13:32

Code:

SELECT category
     , SUM(hours) AS Sumhours
  FROM daTable
 WHERE category IN ( 1 , 2 )
GROUP
    BY category

simple, innit

alexiop · #3 (**permalink**) 07-03-09, 13:43

Quote:

Originally Posted by r937

Code:

SELECT category
     , SUM(hours) AS Sumhours
  FROM daTable
 WHERE category IN ( 1 , 2 )
GROUP
    BY category

simple, innit

Sorry for not explaining clearly but the two queries should be combined into one and your solution is right. but on that how could i get the sum of each category? like sum(hours) as sumhours1 where category=1 and sum(hours) where category=2

thanks again

r937 · #4 (**permalink**) 07-03-09, 14:17

Quote:

Originally Posted by alexiop

...how could i get the sum of each category?

please run my query and inspect the results

Pat Phelan · #5 (**permalink**) 07-03-09, 15:52

alexiop:

The query that r937 gave you may or may not do what you want. That is something that only you can decide.

The query that 937 gave does what you've requested. Take a look at the queries output.

Note that the WHERE clause in this code is something that is necessary to meet your request, but it could be what is keeping you from getting the results that you want.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech