w1coding.comAll tutorials

SQL Groupby

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL GROUP BY Clause

The GROUP BY clause is used to group rows that have the same values into summary rows, often used with aggregate functions like COUNT, SUM, AVG, etc.

Example of GROUP BY

SELECT gender, COUNT(*) AS total_users
FROM Users
GROUP BY gender;
    

This query retrieves the total number of users grouped by gender.