listagg(distinct column) over()

Question

有什么支持listagg(distinct column) over()的替代方案吗？我有20+。。

Answer 1

您可以使用带有row_number()的子查询来标识要包含在listagg()中的第一个值，例如：

select listagg(case when seqnum = 1 then column end) within group (order by column) over (order by ?)
from (select t.*, row_number() over (partition by column order by column) as seqnum
from t
) t