Mysql query to Query Builder

Question

I want to take this SQL query to a query in Laravel Query Builder. It is important that the result be of type Query Builder. Please if you can help me.

SELECT MAX(sub.total) as total, sub.vendedor
FROM
(
    SELECT COUNT(id) as total, vendedor  
    FROM data_reports dr
    GROUP BY vendedor
) sub

I have the following but I couldn't go any further.

$data = DB::table('data_reports')
    ->select(DB::raw('COUNT(id) as total, vendedor'))
    ->groupBy('vendedor');

arya_la · Accepted Answer · 2023-10-20 16:47:11Z

1

Here is the query:

$results = DataReport::select(DB::raw('MAX(sub.total) as total, sub.vendedor'))
->from(function ($query) {
    $query->select(DB::raw('COUNT(id) as total, vendedor'))
        ->from('data_reports')
        ->groupBy('vendedor');
}, 'sub')
->get();

answered Oct 20, 2023 at 16:47

arya_la

5321 gold badge4 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Efratista Over a year ago

Thank you very much arya_la. I modified it so that the result is of type 'Illuminate\\Database\\Query\\Builder' and not 'Illuminate\\Database\\Eloquent\\Builder'

Collectives™ on Stack Overflow

Mysql query to Query Builder

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related