Collections:
Using Subqueries with the IN Operators in SQL Server
How To Use Subqueries with the IN Operators in SQL Server?
✍: FYIcenter.com
A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to use a subquery with the IN operator. It returns all links with ids in the fyi_rates table.
SELECT id, url, tag, YEAR(created) As year FROM fyi_links WHERE id IN (SELECT id FROM fyi_rates) GO id url tag Year 101 dev.fyicenter.com DEV 2006 102 dba.fyicenter.com DBA 2007 103 sqa.fyicenter.com SQA 2007 SELECT id, url, tag, YEAR(created) As year FROM fyi_links WHERE id IN (101, 102, 103, 204, 205, 206, 207) GO id url tag Year 101 dev.fyicenter.com DEV 2006 102 dba.fyicenter.com DBA 2007 103 sqa.fyicenter.com SQA 2007
As you can see, the subquery is equivalent to a list of values.
⇒ Using Subqueries with the EXISTS Operators in SQL Server
⇐ What Is a Subquery in a SELECT Query Statement in SQL Server
⇑ Using SELECT Statements with Joins and Subqueries in SQL Server
2016-10-29, 1357🔥, 0💬
Popular Posts:
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...