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, 1779🔥, 0💬
Popular Posts:
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...