SELECT S.MRKN_REG_NO
, COALESCE(SUM(S.MRKN_APLY_PCHS), 0) AS PCHS /*적용매출*/
, COALESCE(SUM(S.MRKN_APLY_PCHS), 0) AS PCHS /*적용매출*/
, COALESCE(SUM(S.MRKN_APLY_PCHS), 0) AS PCHS /*적용매출*/SELECT div, COALESCE(div, 0) FROM table_a;
if) div =2, COALESCE(div, 0) --> 2
if) div =NULL, COALESCE(div, 0) --> 0
if) div =5, COALESCE(div, 0) --> 5
ex. SELECT A, B, COALESCE(A,B) AS C FROM table_a;
if) A=1, B = NULL --> 1
if) A=NULL, B = 2 --> 2
if) A=NULL, B = NULL --> NULL