Not
The SQL syntax supports the NOT operator, which returns the rows for which the condition is not true. Therefore, looking at the example above, imagine we'd like to return all people that are not from the United States of America, Spain, and Denmark. We can do that by only putting in the NOT keyword, and the query would look like this:
TEXT/X-SQL
1SELECT *
2FROM Person
3WHERE Country NOT IN (‘USA’, ‘Spain’, ‘Denmark’);The resulting table would be:
