SQL IN Operator

SQL IN Operator helps you to specify multiple values in a WHERE Clause.
Understand with Example
The Tutorial illustrate an example from SQL IN Operator. In this
example, we create a table 'Stu_Table'. The create table statement is
used to create a table Stu_Table.
Create Table Stu_Table
create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class varchar(10))
|
Insert data into Stu_Table
The insert into add the records or rows
value to the table 'Stu_Table'.
insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);
insert into Stu_Table values(1,'Komal',10);
|
Stu_Table
| Stu_Id |
Stu_Name |
Stu_Class |
| 1 |
Komal |
10 |
| 2 |
Ajay |
10 |
| 3 |
Rakesh |
10 |
| 4 |
Bhanu |
10 |
| 5 |
Santosh |
10 |
| 1 |
Komal |
10 |
SQL IN Syntax
The SQL IN Syntax is used to return the records
from table specify multiple values in WHERE Clause.
SELECT ColumnName(s)
FROM TableName
WHERE ColumnName IN(value1, value2,...)
|
SQL IN Query
The given below Query return you the records from
table stu_table specifying multiple value in Stu_Name containing name 'komal'
and 'Rakesh'.
SELECT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table
WHERE Stu_Name IN('Komal', 'Rakesh')
|
Result
| Stu_Id |
Stu_Name |
Stu_Class |
| 1 |
Komal |
10 |
| 3 |
Rakesh |
10 |
| 1 |
Komal |
10 |

|