select join distinct code example

Example 1: select distinct laravel

$items = DB::table('item')->select('item_name')->distinct()->get();

Example 2: postgresql distinct

SELECT
	DISTINCT bcolor
FROM
	distinct_demo
ORDER BY
	bcolor;