Find Column Averages Easily - Join StudyWithKishan

0

How to get Average Value of a Column from Database in Laravel

Get Average of a Column in Laravel - StudyWithKishan


                In this article we are going to learn how can you get the average of any column of your database in Laravel . To calculate average of a column in Laravel is very easy but we just need to know the way to write the query . In this article we will see the Laravel Eloquent method for calculating average from Database .

              No Doubt , During the calculation of average you can use multiple where condition and other helper functions and aggregate functions according to your need .

Syntax 1: - 


$data = DB::table('table_name')

                ->where('column_name', 'value')

                ->avg('column_name');

Example 1: -



Syntax 2: -


$data = DB::table('table_name')

                ->where(['column_name' => 'value'])

                ->avg('column_name');


Example 2: -



Syntax 3: -



$data = Model_Name::avg('Column_name');


Example 3: -




These were the three ways to use average query in Laravel.


Thank you for reading this article 😊

For any query do not hesitate to comment 💬

Also Read : -

Laravel Eloquent SQL Update Query

How to add Search functionality in Laravel

Laravel 7/6 Email Verification

Add Date-Time Picker in Laravel

Conversion of Array to String in Laravel

Why Laravel is the Most Popular PHP Framework



Post a Comment

0Comments
Post a Comment (0)