Use of IN Clause

Question

Hello What is the use of In operator in SQL Server?

Prashant Chaudhary · Answer

THANKS

Priya Linge · Answer

Hi, 1.IN Operator :The IN operator allows we to specify multiple values in a WHERE clause. 2.Syntax : SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...) 3.Example : We have Customer Table in that we have FirstName and LastName. FirstName LastName Anil Sharma Sunil Ranavat Kunal Varma SELECT * FROM Customer WHERE LastName IN ('Sharma','Ranavat') OutPut : FirstName LastName Anil Sharma Sunil Ranavat Hope this will help you. Thanks.

Satyapriya Nayak · Answer

Hi Prashant, In SQL, there are two uses of the IN keyword, and this section introduces the one that is related to the WHERE clause. When used in this context, we know exactly the value of the returned values we want to see for at least one of the columns. The syntax for using the IN keyword is as follows: SELECT "column_name" FROM "table_name" WHERE "column_name" IN ('value1', 'value2', ...) The number of values in the parenthesis can be one or more, with each values separated by comma. Values can be numerical or characters. If there is only one value inside the parenthesis, this commend is equivalent to WHERE "column_name" = 'value1' For example, we may wish to select all records for the Los Angeles and the San Diego stores in Table Store_Information, Table Store_Information store_name Sales Date Los Angeles $1500 Jan-05-1999 San Diego $250 Jan-07-1999 San Francisco $300 Jan-08-1999 Boston $700 Jan-08-1999 we key in, SELECT * FROM Store_Information WHERE store_name IN ('Los Angeles', 'San Diego') Result: store_name Sales Date Los Angeles $1500 Jan-05-1999 San Diego $250 Jan-07-1999 Thanks

Pravin More · Answer

hi prashant, you can apply condition on multiple values using IN operator. for e.g:- select * from account where accountid in (1,2,3,4,10,18) above query will give alll matching results if account id is in IN condition. Thanks, Pravin.

Use of IN Clause

Answers (4)