SQL IN Operator

Published on August 18 2015 by LakshmiSaahul,Dhana Royal

SQL IN Operator

You can specify multiple values with IN operator and it will return matching values from WHERE clause of a table. IN operator matches values in a list or subquery and returns the output.

Syntax

SELECT column1, column2,… columnN

FROM TableName

WHERE column IN (Value1, Value2,…ValueN);

SELECT *FROM Student

WHERE FirstName IN ('Gigi', 'Dylan', 'Ken')

Advertising