sql case when 去重

完整sql

SELECT
	md5( uuid( ) ) AS DATAKEY,
	count( DISTINCT PN_NO ) PAY_NUM_MON,
	sum( AMOUNT ) PAY_AMOUNT_MON,
	count(distinct case when DATE_FORMAT( PAY_date, '%Y-%m-%d' ) = DATE_FORMAT( now( ), '%Y-%m-%d' )  then pn_no else null end ) as pay_num,
	sum(case when DATE_FORMAT( PAY_date, '%Y-%m-%d' ) = DATE_FORMAT( now( ), '%Y-%m-%d' )  then AMOUNT else 0 end ) as pay_amount,
	UNIT_CODE,
	UNIT_NAME,
	UNIT_ID,
	'' AS ARRCODE,
	DATE_FORMAT( now( ), '%Y-%m-%d' ) AS COLLECT_DATE,
	PROVINCE AS DIST_CODE,
	'' AS DIST_NAME,
	'kettle' AS CREATE_UNAME,
	now( ) AS CREATE_TIME,
	DATE_FORMAT( now( ), '%Y' ) AS YEAR,
	PROVINCE 
FROM
	nontax_t_receiveddet_${thisMonth}  -- 202106 -- 
-- WHERE DATE_FORMAT( PAY_date, '%Y-%m-%d' ) = DATE_FORMAT( now( ), '%Y-%m-%d' ) 
GROUP BY
	UNIT_CODE,
	UNIT_NAME,
	UNIT_ID,
	province

重点语法：

count(distinct case when DATE_FORMAT( PAY_date, '%Y-%m-%d' ) = DATE_FORMAT( now( ), '%Y-%m-%d' )  then pn_no else null end )