select distinct values in distinct dates postgresql code example Example: postgresql distinct SELECT DISTINCT bcolor FROM distinct_demo ORDER BY bcolor;