What Is In Operator in Sql with Example

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 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