select sum(v.OUTQTY),to_char(v.CREDATE,'yyyy-mm-dd'),to_char(v.CREDATE,'mm'),to_char(v.CREDATE,'yyyy'),v.ENTRYID from bms_st_io_dtl_unit_qry_v v where v.inoutflag='0' GROUP BY to_char(v.CREDATE,'yyyy-mm-dd'),to_char(v.CREDATE,'mm'),to_char(v.CREDATE,'yyyy'),v.ENTRYID |