How to find max sum value for different user in laravel 5.6?

Question

I have 3 'agentid' in this table. Now I want to find the max sum value of 'resolved' for 'agentid'.And also if i want to use where condition for specify 'reportyear' and 'reportmonth' then what should i do? i have...

$currentMonth = date('M'); $currentYear = date('Y');

How can I do it in laravel?

It's work's ....but i want to find the maximum value among them . — Ferdous Bhuiyan
– Ferdous Bhuiyan, Commented Dec 2, 2018 at 8:04
you want sum of resolved of each agent id and get the highest one ? — Rox
– Rox, Commented Dec 2, 2018 at 9:10
yes.thanks.it's work's,but if i want to use where condition for specify 'reportyear' and 'reportmonth' then what should i do? i have $currentMonth = date('M'); $currentYear = date('Y'); — Ferdous Bhuiyan
– Ferdous Bhuiyan, Commented Dec 2, 2018 at 9:48

Rox · Accepted Answer · 2018-12-02 10:38:11Z

1

you want sum of resolved of each agent id and get the highest one ? If so then you can do something like this

$higest_resolved=DB::select(DB::raw('SELECT agentid,SUM(resolved) 
as resolved_total FROM table_name GROUP by agentid ORDER by resolved_total DESC LIMIT 1'));

for adding month and year condition,you can do as

$higest_resolved=DB::select(DB::raw('SELECT agentid,SUM(resolved) 
as resolved_total,reportyear,reportmonth FROM table_name where reportmonth="'.$currentMonth.'" and reportyear="'.$currentYear.'" GROUP by agentid,reportyear,reportmonth ORDER by resolved_total DESC'));

you can still add limit 1 at end to get only one value.

edited Dec 2, 2018 at 10:38

answered Dec 2, 2018 at 9:22

Rox

3617 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How to find max sum value for different user in laravel 5.6?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related