What is GROUP BY clause?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is GROUP BY clause?
Rating:
The GROUP BY clause groups selected rows on the basis of values of specified column(s) for each row, and returns a single row of summary information for each group. Rows that have the same values in the specified grouping column(s) are grouped together. The GROUP BY clause suppresses duplicate rows for the grouping column(s). It does not guarantee the order of the result set. Therefore, an ORDER BY clause should be used with the GROUP BY clause to sort the result set in the desired order.
Rating:
Was this information helpful?
Other articles
- What is the sp_depends stored procedure?
- What are client-activated objects?
- What is MyBase keyword?
- What is the Add method?
- What is a bodiless package?