WHERE IN returns values that matches values in a list or the results of a subquery.

SQL Where IN Syntax:

SELECT Column1, Column2, Column3

FROM Table_Name

WHERE Column1 IN ( Value1, Value2, Value3)

Example:

Lets use the “Orders” table to find all Orders with the ProductID of two, four, and five.

Results:

Lets find all orders with an OrderID greater than 13 using a subquery for the filter.

Results:



SQL Tutorial