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
GROUP BY Clause - Exercise
Objective:
Create a GROUP BY clause to sort and group results from a query.
Consider the following table columns from a table named MyTable:
MyLastName
MyFirstName
MyAddress
MyCity
MyState
MyZipCode
Create a statement that will provide a listing of the unique zip codes in the table with no zip codes duplicated.
When you are done, click the
Submit
button to submit your answer.
Submit