xxxxxxxxxx
DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();
xxxxxxxxxx
$result = Exams::whereNotIn('id', function($q){
$q->select('examId')->from('testresults');
})->get();
xxxxxxxxxx
DB::table('table_employee')
->select('id', 'name')
->where('name', '<>', '')