- SELECT * FROM customers
- WHERE cust_id IN (SELECT DISTINCT cust_id FROM orders WHERE order_value > 5000);
| SQL Subquery Inside Select Statement – MYsql Code |
|---|
|
|
|
SQL Subquery Inside Select Statement
|
Published: | September 28, 2020 |
Author: | admin |
Category: | SQL Advanced, SQL Source Code |
Views: | 24 |
|
This article was posted in SQL Advanced, SQL Source Code and tagged Exercise SQL Subquery Inside Select Statement, How to write SQL Subquery Inside Select Statement, SQL Subquery Inside Select Statement - SQL Example. Bookmark the permalink. Follow comments with the RSS feed for this post.Post a Comment or leave a trackback: Trackback URL.
|
|
|