Unit 3 Discussion: Grouping Data
No unread replies. No replies.
Part IV in your textbook, SQL Queries for Mere Mortals, (3rd ed.), discusses ways to summarize and group data that is retrieved from a database management system using SQL statements. Why might you want to group data? How can you use aggregate functions for grouping purposes? How can we use aggregate functions for filtering purposes? Utilizing the GROUP BY clause in an SQL statement allows us to group easily retrieved data. What are some specific uses for a GROUP BY clause? When we use a GROUP BY clause in an SQL statement some restrictions may apply. Let's discuss common pitfalls and restrictions of the GROUP BY clause in relation to SQL syntax.
In your discussion post: