can sombody tell me clearly how to use 'not in' i cant undersatnd bcoz i am new in sql learning

Question

please tell me

Answer 1

sorry qurey will be like this

select name, id, dob from student where department NOT IN ('eee','cse')

Answer 2

thank you i got it

Answer 3

NOT IN is used to exclude the value

for example

the student table contains id, name, dob, department. .

there are five departments like cse, ece, mech, eee

you need not want the student information from eee and cse

then the code be

select name, id, dob from student where NOT IN department('cse', 'eee')