@@ -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 |