Answers for "select number of distinct values postgres"

postgresql make each element in array distinct

SELECT ARRAY(SELECT DISTINCT unnest(t_column)) FROM t_name;

Posted by: Guest on March-20-2021

postgres count distinct

SELECT 
   COUNT(DISTINCT column) 
FROM 
   table_name
WHERE
   condition;

Posted by: Guest on November-18-2020

Code answers related to "select number of distinct values postgres"