IN Operator use:
It allows us to put multiple values in a where clause . With the help of this we can compare multiple values wtih where.
Syntax:
Select columnname(s) from Tablename where columnname IN(value1,value 2, .... value n);
Example:
SELECT name FROM Employee where city IN('Delhi','Mumbai','Bengaluru');
This query will find those person names who lives either in Delhi or Mumbai or Bengaluru .
0 Comment(s)