Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Laravel Eloquent groupBy() AND also return count of each group

    @ankit.bhatia
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 8.88k
    Comment on it

    We can also make our query on groupBy using Laravel 4.x.Let me demonstrate it by the following example.

    Suppose we have a table in which we have n number of users which are from different-different state and we have to find that how many users belong to particular state.Then we have to run the following query. 

     $userInfo = DB::table('user')->select('state', DB::raw('count(*) as total'))->groupBy('state') ->get();

    Here In the above example we can count the employee of particular state by using groupBy.

    Laravel Eloquent groupBy() AND also return count of each group laravel 4.x
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: