SQL Oracle PHP Java JSP JDBC MORE

SQL IN Operator with Example


In SQL the 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 IN ('Pune', 'Mumbai');

Output

Sl No Name City Email ID
2 Sachin Mumbai sachin@gmail.com
4 Raina Pune raina@gmail.com