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
⇒ What Are Logical/Boolean Operations in SQL Server
⇐ EXISTS - Testing Subquery Results in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1328🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...