1(NOT) operator excluding given
2For example:
3Select last_name, job_id From Employees
4Where "Not" job_id = 'ABC';
5
1SQL NOT IN operator is used to filter the result if the values that are mentioned as part of the IN operator is not satisfied. Let’s discuss in detail about SQL NOT IN operator.
2
3Syntax:
4SELECT Column(s) FROM table_name WHERE Column NOT IN (value1, value2... valueN);
1Used to join separate conditions within a WHERE clause.
2Example: Returns events located in London, United Kingdom
3SELECT * FROM events
4WHERE host_country='United Kingdom' AND host_
5city='London';