WM_Concat Function
SELECT qt_test.bus_unit, wm_concat(qt_test.sales) sales_data, SUM(sales) sales_totals FROM (SELECT 10 as bus_unit, 2000 sales from dual UNION ALL SELECT 10 as bus_unit, 2500 sales from dual UNION ALL SELECT 20 as bus_unit, 2500 sales from dual UNION ALL SELECT 20 as bus_unit, 1500 sales from dual UNION ALL SELECT 20 as bus_unit, 1500 sales from dual UNION ALL SELECT 10 as bus_unit, 2500 sales from dual UNION ALL SELECT 30 as bus_unit, 4500 sales from dual UNION ALL SELECT 30 as bus_unit, 3000 sales from dual UNION ALL SELECT 30 as bus_unit, 4000 sales from dual ) qt_test GROUP BY qt_test.bus_unit;
74690