Answers for "from join select distinct by select new model"

PHP
8

select join distinct

$items = DB::table('item')->select('item_name')->distinct()->get();
Posted by: Guest on June-30-2020
0

select distinct after join

SELECT DISTINCT table1.field1, table2.field2 FROM table1
JOIN table2 ON table1.id = table2.id
Posted by: Guest on September-28-2021

Browse Popular Code Answers by Language