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 a year ago223 views
1 Answer
0

Hello meyerovb,

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

profile pictureAWS
answered a year 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.

Guidelines for Answering Questions