What is IN Logical Operator in SQL Server - SQL Server / TSQL Tutorial Part 122

preview_player
Показать описание
SQL Server / T-SQL Tutorial Scenario:
What is IN Logical Operator :
IN logical operator is used when we want to return the row if specified value matches with any value in the sub-query or a list.

The IN Logical operator is going to be true if the operand is equal to one of the list of expressions.

Let's say that we have dbo.Customer table with below rows. We want to return the rows where CountryShortName is equal to 'PK' OR 'US'.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
Рекомендации по теме
Комментарии
Автор

Thanks for posting nice explanation on returning the Null values

PeteSkylakos
welcome to shbcf.ru