I want to get numbers of student in each class. i used this query before.
$group=DB::table('students')->groupBy('class');
What will be the query for getting student numbers in each class? please help
Asked
Active
Viewed 46 times
0
-
`$classes=Class::withCount('students')->get();` – Christophe Hubert Apr 29 '20 at 19:42
-
I have students table. all datastored there. now i want to get the numbers of students in each class from students table.. – tariqul anik Apr 29 '20 at 19:43
-
1DB::table('students')->select('class', DB::raw('count(*) as total_students'))->groupBy('class'); – Mohammad.Kaab Apr 29 '20 at 19:46
-
thanks bro.it works... – tariqul anik Apr 29 '20 at 21:05