Sql operator and function | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Sql operator and function

I want to select a list of every individual in a table (customer) who are not in a location say 'brazil' ... Should I use the NOT IN function or '! =' or `<>` Which of the three is best for the WHERE CLAUSE to work with and give accurate results?

18th Dec 2016, 2:43 PM
Tukele Osareme C
Tukele Osareme C - avatar
2 Answers
0
select (what u want to select) from customer where location not in ('brazil'); try this out..it should work
18th Dec 2016, 6:15 PM
Harshit
0
Alright thanks
18th Dec 2016, 6:18 PM
Tukele Osareme C
Tukele Osareme C - avatar