$devices = Device::groupBy('serial_no')->orderByDesc('serial_no')->get(); ++++++++++++++++++++ SQL QUERY +++++++++++++++ SELECT sum(in_stock) stock, some_field2, some_field3 FROM some_table GROUP BY some_field2, some_field3 ORDER BY some_field1