Hi All
Can multiple group by clause be used in single query. The requirement is to have a group by on three combinations . I have a table with composite keys
Say A,B,C ,
The group by's have to done on
1] A,B
2] A,C
3] A

Can it be done using single query, or three different queries have to be done for three combinations.
Please advice

possibly "group by grouping sets ... "

Thanks for the reply

i tried this query but it results in error

SELECT ER_NBR, INSTR_ID, sum( STRT_INSTR_PRICE ) AS pris
FROM MATB252
GROUP BY GROUPING
SETS(( ER_NBR ))


DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: SETS;UNION

Any idea .

are you on mainfraame? of luw?

what db2 version are you on?

Its Unix ,DB2 7.2

In this example, try including instr_id in the grouping sets.