[Oracle] Count 관련

[Oracle] Count 관련 

- 중복제거, Null 제거

WITH TEMP_TABLE AS ( SELECT '1' Col1, '1' Col2, '1' Col3, '1' Col4 FROM DUAL UNION ALL SELECT '2' Col1, '2' Col2, '2' Col3, '2' Col4 FROM DUAL UNION ALL SELECT '3' Col1, '3' Col2, '3' Col3, '3' Col4 FROM DUAL UNION ALL SELECT '4' Col1, '1' Col2, NULL Col3, ' ' Col4 FROM DUAL UNION ALL SELECT '5' Col1, '1' Col2, ' ' Col3, '1' Col4 FROM DUAL ) SELECT COUNT(*) Row수, COUNT(Col1) Col1수, COUNT(Col3) Col3수, COUNT(Col4) Col4수, COUNT(DISTINCT Col2) Col2중복제거수, COUNT(DISTINCT Col4) Col4중복제거수, COUNT(CASE WHEN NVL(Col4,' ') != ' ' THEN 1 ELSE 0 END) Col4공백이아닌수, COUNT(DISTINCT CASE WHEN NVL(Col4,' ') != ' ' THEN Col4 END) Col4공백이아닌중복제거수 FROM TEMP_TABLE;