SQL统计1-12月的数据，没有数据的月份显示为0

1.利用临时表补足数据（HANA）

select A.DATAYEAR as DATAYEAR, A.DATAMONTH as DATAMONTH,sum(DATANUM) as DATANUM from 
(select YEAR(GL_LZ_XKTZ_NY) as DATAYEAR,Month(GL_LZ_XKTZ_NY) as DATAMONTH,count(*) as DATANUM
from TableName
where Year(GL_LZ_XKTZ_NY) >= year(ADD_YEARS(current_date,-1)) and  Year(GL_LZ_XKTZ_NY) <= year(current_date)
group by YEAR(GL_LZ_XKTZ_NY) , Month(GL_LZ_XKTZ_NY)  
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR, 1  as DATAMONTH , 0  as DATANUM from DUMMY
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR, 2  as DATAMONTH , 0  as DATANUM from DUMMY
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR, 3  as DATAMONTH , 0  as DATANUM from DUMMY
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR, 4  as DATAMONTH , 0  as DATANUM from DUMMY
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR, 5  as DATAMONTH , 0  as DATANUM from DUMMY
union 
select year(ADD_YEARS(current_date,-1)) as DATAYEAR,