CODEWITHSUNDEEP
phpmysqllaravelquery-builder
user4006175
user4006175

Reputation: 399

laravel query php how to get max value within a range

hello how do i get the max value of scores, where column ID range starts at 3-5 example table enter image description here

I want to get the max value of scores, where column ID ranging from 3-5 , please help,

what I have done so far:

$max_scores_table= DB::table('scores_table')
->where('id', '>', 2)
->max('score');

another problem is when i have a decimal points in the table when I used the max() function it gets the ID=5, which has a Score of 4.5, instead of ID=4 with a value of 4.6, tnx in advance

Upvotes: 5

Views: 9997

Answers (3)

Ganesh Ghalame
Ganesh Ghalame

Reputation: 7003

Write query as below:

$max_scores_table = DB::table('scores_table')
     ->whereBetween('id',array(3,5))
     ->max('score');

Reference: Laravel API

Upvotes: 2

RaMeSh
RaMeSh

Reputation: 3424

Use query like this

$max_scores_table = DB::table('scores_table')
                    ->whereBetween('id', array(3, 5))->max('score')->get();

For your reference just follow Laravel Documentation

Upvotes: 0

aldrin27
aldrin27

Reputation: 3407

Try to use whereBetween hope this works:

$max_scores_table= DB::table('scores_table')
    ->select(DB::raw('MAX(score) FROM scores_table as MaxScore'))
    ->whereBetween('id', array(3,5))
    ->where('score', 'MaxScore')
    ->get();

OR:

$max_scores_table= DB::table('scores_table')
    ->whereBetween('id', array(3,5))
    ->max('score')
    ->get();

Upvotes: 6

Related Questions