SQL IN Operator

SQL IN Operator is used in SQL statements with in WHERE clause to specify multiple values in SQL IN Operator.

SQL IN Operator Code Syntax :

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

Sample code for SQL IN Operator :

In this SQL statements, results will be retrieved based on the names column if it matches name1 & name2.

SELECT * FROM Users
WHERE Name IN (‘name1′,’name2’);

Vivek Vengala
 

Vivek Vengala is a Online Entrepreneur, Web Developer from Hyderabad India.

Click Here to Leave a Comment Below 0 comments

Leave a Reply:

x

Join My Facebook Group to Receive Coding Tutorial for Free

email-subsribe