/SQL/Array aggre distinct postgres

Array aggre distinct postgres

Array aggre distinct postgres

SELECT ARRAY(SELECT DISTINCT e FROM unnest(ARRAY[a,b,c,d]) AS a(e))
FROM ( VALUES
  ('foo', 'bar', 'foo', 'baz' )
) AS t(a,b,c,d);

0

Source: dba.stackexchange.com

Similar codes

2 votes265 views2 answers
Mysql get last character of string
SQL
0 vote303 views1 answer
Mql5 list all available symbols
SQL
7 votes295 views4 answers
How to reset the identity column in sql server
SQL
-2 votes318 views1 answer
Group functions in sql
SQL
0 vote328 views1 answer
Insert or update sql query
SQL
0 vote328 views1 answer
Top frequency in sql server
SQL
20 votes300 views5 answers
Mysql reset auto increment to 1
SQL
0 vote306 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
1 vote291 views1 answer
Sql comment header
SQL
-1 vote339 views5 answers
Not in sql
SQL

Share