Search code examples
mysqlsqllaraveleloquentdistinct

Laravel Eloquent Equivalent for MYSQL DISTINCT query multiple columns


Is there an equivalent query for this in eloquent?

 SELECT DISTINCT agent_code,ord_amount FROM orders

Solution

  • Try something like this:

    Order::select('agent_code', 'ord_amount')->distinct()->get();