laravel query builder count code example

Example 1: laravel select count

$count = DB::table('category_issue')->count();

Example 2: laravel having

$users = DB::table('users')
                ->groupBy('account_id')
                ->having('account_id', '>', 100)
                ->get();