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, 1446🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...