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, 1410🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...