Select query for sum of hours

The sql query below returns data in the 'note' field from a table called ww_rec_1 from the previous month and displays the sum of hours for each category.

SELECT note,SUM(hours)FROM WW_REC_1
where trans_date between
last_DAY(ADD_MONTHS(SYSDATE, -2))+1
and LAST_DAY(ADD_MONTHS(SYSDATE,-1))
GROUP BY NOTE This is the returned data:

"NOTE", "SUM(HOURS)"

"ACT", -330864.75
"CHG", -165.25
"EXT", 331108.5
"INT", 45
I need to add together the sum of hours for specified data in the note field. So in this case I want to add together the sum of hours for 'ACT' and 'CHG'. I also need to add together the sum of hours for 'EXT' and 'INT'.

Can anyone help me out with this?

Thanks in advance

George Received on Tue Aug 10 2004 - 16:19:55 CEST