解题和评论里都用的group_concat函数,我用了listagg函数,不懂为啥不可以??
select substr(sell_date,1,10) sell_date,count(distinct product) num_sold,listagg(product,',') within group(order by product) products
from Activities
group by sell_date
order by sell_date
你需要在加工一下,因为这样写listagg并没有去除重复项:Mask