50+ Useful Laravel Quries (Part - 3)

18. LARAVEL MAX QUERY

Using Model (way1)
$data = exampleModel::all()->max('salary');
dd($data);

Using Model (way2)
$data = exampleModel::get()->max('salary');
dd($data);

Using DB Query 
$data = DB::table('example_table')->max('age');
dd($data);

Example #1 
$data = DB::select(DB::raw('select * from example_table where id = (select max(`id`) from example_table)'));
dd($data);

Example #2 
$data = exampleModel::whereRaw('id = (select max(`id`) from example_table)')->get();
dd($data);

Example #3 
$data = DB::table('example_table')->find(DB::table('example_table')->max('id'));
dd($data);

Example #4 
$data = exampleModel::find(DB::table('example_table')->max('id'));
dd($data);


19. LARAVEL MIN QUERY

Using Model (way1)
$data = exampleModel::all()->min('salary');
dd($data);

Using Model (way2)
$data = exampleModel::get()->min('salary');
dd($data);

Using DB Query 
$data = DB::table('example_table')->min('age');
dd($data);

Example #1 
$data = DB::select(DB::raw('select * from example_table where id = (select min(`id`) from example_table)'));
dd($data);

Example #2 
$data = exampleModel::whereRaw('id = (select min(`id`) from example_table)')->get();
dd($data);

Example #3 
$data = DB::table('example_table')->find(DB::table('example_table')->min('id'));
dd($data);

Example #4 
$data = exampleModel::find(DB::table('example_table')->min('id'));
dd($data);

Example #5 
$data = exampleModel::where('id', '>', DB::table('example_table')->min('id'))
->where('id', '<', DB::table('example_table')->max('id'))
        ->get();
dd($data);


20. LARAVEL AVG QUERY

Using Model (way1)
$data = exampleModel::all()->avg('salary');
dd($data);

Using Model (way2)
$data = exampleModel::get()->avg('salary');
dd($data);

Using DB Query 
$data = DB::table('example_table')->avg('age');
dd($data);


21. LARAVEL SUM QUERY

Using Model (way1)
$data = exampleModel::all()->sum('salary');
dd($data);

Using Model (way2)
$data = exampleModel::get()->sum('salary');
dd($data);

Using DB Query 
$data = DB::table('example_table')->sum('age');
dd($data);