postgres distinct example
Example 1: postgresql distinct
SELECT
DISTINCT bcolor
FROM
distinct_demo
ORDER BY
bcolor;
Example 2: psql select unique
SELECT
DISTINCT column1
FROM
table_name;
SELECT
DISTINCT bcolor
FROM
distinct_demo
ORDER BY
bcolor;
SELECT
DISTINCT column1
FROM
table_name;