How to Work with IN Operator in SQL
In this article I am going to explain how to work with IN Operator in SQL.IN Operator
Introduction
In this article I am going to explain how to work with IN operator in SQL. IN operator is used to test whether an expression is equal to a value in a list of expression. We use IN operator with WHERE clause. We use it to find the specific record into result set from table stored in database. It is used to fetch specific row or specific record based on comparison.
Example
SELECT * FROM dbo.mcninvoices
WHERE invoiceid IN (1,4,6,7)
|
Output