Collections:
EXISTS - Testing Subquery Results in SQL Server
How To Test Subquery Results with the EXISTS Operator in SQL Server Transact-SQL?
✍: FYIcenter.com
EXISTS is a special operator used to test subquery results. EXISTS can be used in two ways:
EXISTS (SELECT ...) -- Returns TRUE if the specified subquery has one or more rows returned. NOT EXISTS (SELECT ...) -- Returns TRUE if the specified subquery no rows returned.
The following tutorial exercise shows you two examples of EXISTS operators. The sample database AdventureWorksLT provided by Microsoft is used.
USE AdventureWorksLT GO -- Number of customers with orders SELECT COUNT(*) FROM SalesLT.Customer c WHERE EXISTS ( SELECT * FROM SalesLT.SalesOrderHeader s WHERE s.CustomerID = c.CustomerID ) GO 32 -- Number of customers without orders SELECT COUNT(*) FROM SalesLT.Customer c WHERE NOT EXISTS ( SELECT * FROM SalesLT.SalesOrderHeader s WHERE s.CustomerID = c.CustomerID ) 408
⇒ IN - Testing Values Returned by a Subquery in SQL Server
⇐ Using Wildcard Characters in LIKE Operations in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-21, 1416🔥, 0💬
Popular Posts:
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...