Collections:
IN - Testing Values Returned by a Subquery in SQL Server
How To Test Values Returned by a Subquery with the IN Operator in SQL Server Transact-SQL?
✍: FYIcenter.com
Normally, the comparison operator IN is used against a list of specified values as in the format of: "test_value IN (value_1, value_2, ..., value_n)". But you can also replace the list of values by a subquery as the following formats:
test_value IN (SELECT column FROM ...) -- Returns TRUE if the test_value equals to one of the values returned from the subquery test_value NOT IN (SELECT column FROM ...) -- Returns TRUE if the test_value does not equal to any of the values returned from the subquery
The following tutorial exercise shows you two examples of IN operators. The sample database AdventureWorksLT provided by Microsoft is used.
USE adventureWorksLT GO SELECT COUNT(*) FROM SalesLT.Customer c WHERE c.CustomerID IN ( SELECT s.CustomerID FROM SalesLT.SalesOrderHeader s ) GO 32 SELECT COUNT(*) FROM SalesLT.Customer c WHERE c.CustomerID NOT IN ( SELECT s.CustomerID FROM SalesLT.SalesOrderHeader s ) GO 408
Â
⇒Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1229👍, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...