Collections:
Using Subqueries with the IN Operator in MySQL
How To Use Subqueries with the IN Operator in MySQL?
✍: 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)
⇒ Using Subqueries with the EXISTS Operator in MySQL
2017-09-17, 1461🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...