Laravel get highest value of each column

Question

I'm using Laravel 5.5, And I want to know how can we get highest value of each column in one query ?

Is that possible or we should query one by one ?

I tried below code.

DB::table('family')->max('children')->max('salary');

When I tried just DB::table('family')->max('children'), It works well. But when I try DB::table('family')->max('children')->max('salary'), I get below error

Call to a member function max() on string

What have you tried so far? Please see this guide on how to ask questions on Stack Overflow: [Link here](https://stackoverflow.com/help/how-to-ask) — Blundering Philosopher, Dec 17 '17 at 12:57
@BlunderingPhilosopher i didnt try anything because i didnt know how to do that , just asked question to know — , Dec 17 '17 at 13:37

score 1 · Answer 1 · edited Jun 20 '20 at 09:12

1

Add max() with your eloquent to get the maximum value of each column value.

ModelName::select(DB::raw('MAX(column1) AS colum1'),DB::raw('MAX(colum2) AS colum2'))->get();

check this laravel docs

Edit: You can do it with query builder in laravel.

edited Jun 20 '20 at 09:12

Community

1
1

answered Dec 17 '17 at 11:21

ARUN Madathil

896
10
16

when i try DB::table('family')->max('children) it works well , but when i try DB::table('family')->max('children)->max('salary') the result is "Call to a member function max() on string" – Dec 17 '17 at 12:02

score 1 · Accepted Answer · answered Dec 17 '17 at 13:50

1

You can get either by single query.

$result = DB::table("family as f")
->select([DB::raw('MAX(f.children) AS children_max'),DB::raw('MAX(f.salary) AS salary_max')])
->groupBy('f.id')
->first();

Or using separate ->max() method.

$family = DB::table('family');
$max_children = $family->max('children');
$max_salary = $family->max('salary');

Get more details in other answer and in Laravel Docs

answered Dec 17 '17 at 13:50

Niklesh Raut

34,013
16
75
109

you are a hero works very well , but which method you prefer for higher speed? – Dec 17 '17 at 14:05
Although second solution is cleaner but first is faster, use according to your use, first is preferred. – Niklesh Raut Dec 17 '17 at 14:07
I didn't down-vote, but I just suggesting you, always add your try, I am adding your comment in your question – Niklesh Raut Dec 17 '17 at 14:08
@user2468 Okay , i see , Thank you again – Dec 17 '17 at 14:14

Laravel get highest value of each column

2 Answers2