RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Select Statement
«Prev
Info Retrieval
Select Statement
What is GroupBy Clause
Group by Clause Insights
Group BY vs. Sorting
SQL Select- Quiz
SQL Subquery Statements
SQL Views
Understand SQL Views
How views are called?
Steps to Create View
Updating Table Row Views
Updating Table with View
SQL Views - Quiz
Key Sql Functions
SQL Function Overview
String | Substring Queries
Upper Lower Functions
SQL Length Function
SQL Trim Function
SQL Arithmetic Functions
SQL Sum Function
SQL Average Function
min-max Functions
SQL Date Functions
Date Function Related Issues
SQL Dateadd Function
SQL Datediff Function
SQL Datepart Function
Date Function - Exercise
Getdate | sysdate Today
SQL Function Conclusion
SQL Reporting
Use SQL Subquery statement
Objective:
Create a sub-SELECT statement using the IN keyword.
Given the following two tables:
MyCustomers
MyOrders
Table name: MyCustomers
CustomerID
Lastname
Firstname
Address
City
State
ZipCode
Classification
Table name: MyOrders
OrderID
CustomerID
OrderAmount
Create a sub-SELECT statement that will show the OrderAmounts for all Customers with a classification of "A".
Submit