MySQL SQL - How To Use Subqueries with the IN Operator
Interview Question Database For Software Developers
|
|
| How To Use Subqueries with the IN Operator | | How To Use Subqueries with the IN Operator? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries | | By: 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.
mysql> SELECT id, url, tag, YEAR(created) As year
FROM fyi_links WHERE id IN (SELECT id FROM fyi_rates);
+-----+-------------------+------+------+
| id | url | tag | year |
+-----+-------------------+------+------+
| 101 | dev.fyicenter.com | DEV | 2006 |
| 102 | dba.fyicenter.com | DBA | 2006 |
| 103 | sqa.fyicenter.com | SQA | 2006 |
+-----+-------------------+------+------+
3 rows in set (0.06 sec)
| | ID: 1157 | Rank: 1083 | Votes: 0 | Views: 54 | Submitted: 20070511 |
1100
:-) | | What Is a Subquery | | What Is a Subquery? - MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries... | | Submitted: 20070511 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view