我想在Laravel Query Builder中使用此SQL查询进行查询.重要的是,结果是Query Builder类型.如果你能帮我的话请帮帮我.
SELECT MAX(sub.total) as total, sub.vendedor
FROM
(
SELECT COUNT(id) as total, vendedor
FROM data_reports dr
GROUP BY vendedor
) sub
我有以下几点,但我不能再继续下go 了.
$data = DB::table('data_reports')
->select(DB::raw('COUNT(id) as total, vendedor'))
->groupBy('vendedor');