@@ -40,12 +40,12 @@ |
||
| 40 | 40 | */ |
| 41 | 41 | public function handle() |
| 42 | 42 | { |
| 43 | - $students = DB::table('examination_students as es') |
|
| 44 | - ->select(DB::raw('count(*) as total'),'e2.*') |
|
| 45 | - ->join('examination_students as e2','es.nsid','e2.nsid') |
|
| 46 | - ->having('total','>',1) |
|
| 47 | - ->groupBy('e2.st_no') |
|
| 48 | - ->orderBy('e2.st_no') |
|
| 43 | + $students = DB::table('examination_students as es') |
|
| 44 | + ->select(DB::raw('count(*) as total'),'e2.*') |
|
| 45 | + ->join('examination_students as e2','es.nsid','e2.nsid') |
|
| 46 | + ->having('total','>',1) |
|
| 47 | + ->groupBy('e2.st_no') |
|
| 48 | + ->orderBy('e2.st_no') |
|
| 49 | 49 | ->get(); |
| 50 | 50 | $this->output->writeln(count($students).'entries found'); |
| 51 | 51 | |