Skip to content

Where's the documentation for listaggdistinct?

0

Last 2 statements do the same thing, but where's the syntax documentation for "listaggdistinct"?

create temp table t(a int, b int);
insert into t values(1,2),(1,2),(2,2);
select listagg(a), b from t group by b;
select listagg(distinct a), b from t group by b;
select listaggdistinct(a), b from t group by b;
asked 3 years ago398 views
1 Answer
0

Hello meyerovb,

You can find LISTTAG Syntax here, which includes information on the DISTINCT argument.

AWS
answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.