Menu

SQL NOT IN Operator with Example


In SQL the NOT IN operator used to compare a column with one or more than one value.

It always used with where clause.

SQL IN Operator Syntax

To add a column in a table, the syntax is

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);
Example

Suppose we have to fetch all record from the user_table where city name is equal to Pune, Mumbai.In this case we have to use IN operator.

Sl No Name City Email ID
1 Virat Delhi virat@gmail.com
2 Sachin Mumbai sachin@gmail.com
3 Dhoni Ranchi dhoni@gmail.com
4 Raina Pune raina@gmail.com
SELECT * FROM Customers WHERE City NOT IN ('Pune', 'Mumbai');

Output

Sl No Name City Email ID
1 Virat Delhi virat@gmail.com
3 Dhoni Ranchi dhoni@gmail.com







Connection failed: SQLSTATE[28000] [1045] Access denied for user 'studentdb'@'localhost' (using password: YES)

Subscribe