- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 73字
- 2021-08-20 10:06:14
Subquery
A Select statement under the select statement is called a subquery. This sub statement can be used to select the column or in conditional cases. A subquery can also be nested within another query statement like INSERT, UPDATE, or DELETE.
The following query returns a set of users who are located in Ahmedabad using a subquery:
SELECT firstName, lastName FROM users
WHERE city IN
(SELECT city FROM cities WHERE city = 'Ahmedabad');
推薦閱讀
- DBA攻堅指南:左手Oracle,右手MySQL
- Mastering Selenium WebDriver
- 深入淺出WPF
- Java Web應用開發技術與案例教程(第2版)
- 算法訓練營:提高篇(全彩版)
- 常用工具軟件立體化教程(微課版)
- Red Hat Enterprise Linux Troubleshooting Guide
- OpenMP核心技術指南
- Node.js應用開發
- Android從入門到精通
- Python深度學習入門:從零構建CNN和RNN
- Flink原理深入與編程實戰:Scala+Java(微課視頻版)
- Selenium WebDriver自動化測試完全指南
- Scratch少兒編程思維訓練:培養孩子的邏輯思維和計算思維能力
- Learn Spring for Android Application Development