Can somebody explain the use of NOT and its Syntex? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Can somebody explain the use of NOT and its Syntex?

from examples I learned NOT is used before condition. not inside the condition. and it's used to make a condition negative.

3rd Mar 2016, 7:22 AM
Dear SaFii
Dear SaFii - avatar
2 Answers
+ 2
select customer_name from where city not in ('Tokyo',La') this will give the answer that customer_name which are not from Tokyo or La
23rd Feb 2016, 3:37 AM
PRAVEEN SINGH RAJPUT (PRINCE)
PRAVEEN SINGH RAJPUT (PRINCE) - avatar
+ 2
select * from tableA where column1 not in (1,2,3)
16th Apr 2016, 4:43 PM
Jonathan Baynes