case when和where

注意:SQL语句中如果null换成0,就有问题了.
1! =3 =2

1. SELECT T.PERIOD_CODE, T.LEAVE_FLAG,T.EMPL_STATUS,
   COUNT(case when T.EMPL_STATUS=‘在职’ THEN 1 ELSE 0 END) AS TOTAL1
   FROM dm_hr_empl_detail T
   WHERE PERIOD_CODE=‘2021-05’

2. SELECT T.PERIOD_CODE, T.LEAVE_FLAG,T.EMPL_STATUS,COUNT(*) FROM
   dm_hr_empl_detail T
   WHERE T.EMPL_STATUS=‘在职’ AND PERIOD_CODE=‘2021-05’

3. SELECT T.PERIOD_CODE, T.LEAVE_FLAG,T.EMPL_STATUS,
   COUNT(case when T.EMPL_STATUS=‘在职’ THEN 1 ELSE NULL END) AS TOTAL1
   FROM dm_hr_empl_detail T
   WHERE PERIOD_CODE=‘2021-05’