oracle怎么根据时间年月查询同期数量

Question

sql怎么根据时间年月查询本期数量和同期数量

select to_char(CREDATE,'mm') CREDATE,to_char(CREDATE,'yyyy-mm') yearn,to_char(CREDATE,'yyyy') yearns,nvl(sum(inqty),0)inqty,nvl(sum(OUTQTY),0) OUTQTY
  from BMS_ST_IO_UNION_V 
        group by to_char(CREDATE,'mm'),to_char(CREDATE,'yyyy'),to_char(CREDATE,'yyyy-mm')  order by CREDATE,inqty,OUTQTY,yearn

 

 

 

 

 

 

Answer 1

需要具体贴出数据或者字段才能编写出SQL语句