Select to_char (s.SLICE_DATE,'MON') Slice_Date, r.unique_name, r.NAME, SUM(nvl(round(s.slice,2),0)) Slice_Var From PRJ_BLB_SLICES s, PRASSIGNMENT pra, PRTask t, SRM_PROJECTS r where s.prj_object_id = pra.prid and pra.prtaskid = t.prid and r.ID = t.prprojectid and r.IS_ACTIVE = 1 and slice_request_id = 5 and s.slice_date = '01-OCT-13' Group by (to_char (s.SLICE_DATE,'MON')), r.unique_name, r.NAME MINUS Select to_char (s.SLICE_DATE,'MON') Slice_Date, r.unique_name, r.NAME, SUM(nvl(round(s.slice,2),0)) Slice_Var From Niku.PRJ_BLB_SLICES s, Niku.PRASSIGNMENT pra, Niku.PRTask t, Niku.SRM_PROJECTS r where s.prj_object_id = pra.prid and pra.prtaskid = t.prid and r.ID = t.prprojectid and r.IS_ACTIVE = 1 and slice_request_id = 3 and s.slice_date Between '01-OCT-13' AND '31-OCT-13' Group by (to_char (s.SLICE_DATE,'MON')), r.unique_name, r.NAME Order By 1 Asc, 2 Asc