get distinct first records in postgresql code example

Example: postgresql distinct

SELECT
	DISTINCT bcolor
FROM
	distinct_demo
ORDER BY
	bcolor;