【Oracle】不使用distinct去重和listagg合并函数、某年某个月

表：

合并

SELECT
	a.MOOD_DATE,
	listagg ( a.icon_type, ',' ) within GROUP ( ORDER BY a.icon_type ) AS iconlist 
FROM
	表名 a 
GROUP BY
	a.MOOD_DATE;

显示结果：

去重：

SELECT
	to_char( MOOD_DATE, 'yyyy-mm-dd' ) "MOOD_DATE",
	LISTAGG ( icon_type, ',' ) within GROUP ( ORDER BY icon_type ) "icon_type" 
FROM
	( SELECT DISTINCT MOOD_DATE, icon_type FROM 表名 ) t 
GROUP BY
	MOOD_DATE 
ORDER BY
	MOOD_DATE

显示结果：
某年某月某日

SELECT
	* 
FROM
	SZCD_PARTY_DAILY_MOOD 
WHERE
	Extract( year FROM MOOD_DATE ) = 2022 # 某年 
	AND Extract( month FROM MOOD_DATE ) = 8 # 某月 
	AND Extract( day FROM MOOD_DATE ) = 17 # 某日

将这个条件加入前面的sql语句中
【查询某个日期的当年当月的每天的图标类型】

SELECT
	to_char( MOOD_DATE, 'yyyy-mm-dd' ) "MOOD_DATE",
	LISTAGG ( icon_type, ',' ) within GROUP ( ORDER BY icon_type ) "icon_type" 
FROM
	( 
		SELECT DISTINCT MOOD_DATE, icon_type FROM 表名
		WHERE Extract( year FROM MOOD_DATE ) = 2022 
		AND Extract( month FROM MOOD_DATE ) = 8 
	) t 
GROUP BY
	MOOD_DATE 
ORDER BY
	MOOD_DATE

ps：由于数据比较少，所以暂时这样，如果有任何问题或者更好的方法可以交流下