duanben4771 2014-12-29 08:16
浏览 13
已采纳

Eloquent选择每个不同的'id'的第一个?

I have an employee table with a field district_id. I want a query that selects the first employee from each district.

At the moment I'm manually hardcoding it:

$tributes = [
Employee::where('district_id', '=' 1)->take(1)->get(),
Employee::where('district_id', '=' 2)->take(1)->get(),
Employee::where('district_id', '=' 3)->take(1)->get(),
...
];

Is it possible to do this using only one eloquent call? Any volunteers?

  • 写回答

2条回答 默认 最新

  • dsfdfdfd6576578 2014-12-29 10:45
    关注

    I am not used to laravel. But something like below may help. Group by is needed for one employee and ascending ID will confirm the first employee.

    Employee::whereIn('district_id', array(1, 2, 3))
                ->orderBy('employee_id', 'asc')
                ->groupBy('employee_id')                
                ->get();
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?