0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

-- Enter Query Title
-- Enter Query Description

-- Sample for 8394221

WITH DATA AS
( SELECT 'A' as Cat, 1 as subcat, 123 as amount
  UNION SELECT 'A', 2, 456
  UNION SELECT 'B', 1, 222
  UNION SELECT 'B', 2, 333
  UNION SELECT 'B', 3, 444
) , CONFIG as
( SELECT 'B' as cat , 1 as subcat) 

SELECT 
   
        d.cat, d.subcat, c.subcat, sum(amount) amount
        ,GROUPING(c.subcat)
FROM   data d 
LEFT JOIN config c
ON d.cat = c.cat 

    
GROUP BY
 d.cat  , d.subcat , c.subcat with rollup


 

fork query

created dec 6 11 conradfrix