Oracle 多个字段去重

SELECT
DISTINCT SUBSTR(d.DEPT_ID, 0, 2) DEPT,d.SECURITY_CHECK --截取前俩位判断去重复
FROM
SAF_T_INSPECTION_DEPT d

SELECT
	A .desc_,
	A .ID_,
	B.CHECK_TYPE
FROM
	(
		SELECT
			*
		FROM
			BDF2_DEPT D
		WHERE
			D .parent_id_ = '00'
		AND D .level_ = '1'
	) A
LEFT JOIN (
	SELECT
		DEPT,
		CHECK_TYPE
	FROM
		(
			SELECT
				*
			FROM
				SECURITY_CHECK c
			WHERE
				c.DEL_FLAG = '0'
			AND c.CHECK_DATE >= TO_DATE ('2019-01-01', 'yyyy-MM-dd')
			AND c.CHECK_DATE <= TO_DATE ('2019-12-31', 'yyyy-MM-dd')
		) cc
	LEFT JOIN (
		SELECT DISTINCT
			SUBSTR (DEPT_ID, 0, 2) DEPT,
			SECURITY_CHECK
		FROM
			SAF_T_INSPECTION_DEPT
	) i ON cc.SECURITY_CHECK_ID = i.SECURITY_CHECK
) b ON A .id_ = b.DEPT