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, 1317🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...