Why do we need GROUP BY with AGGREGATE FUNCTIONS?

by

It might be easier if you think of GROUP BY as “for each” for the sake of explanation. The query below:

SELECT empid, SUM (MonthlySalary) 
FROM Employee
GROUP BY EmpID

is saying:

“Give me the sum of MonthlySalary’s for each empid”

So if your table looked like this:

+-----+------------+
|empid|MontlySalary|
+-----+------------+
|1    |200         |
+-----+------------+
|2    |300         |
+-----+------------+

result:

+-+---+
|1|200|
+-+---+
|2|300|
+-+---+

Sum wouldn’t appear to do anything because the sum of one number is that number. On the other hand if it looked like this:

+-----+------------+
|empid|MontlySalary|
+-----+------------+
|1    |200         |
+-----+------------+
|1    |300         |
+-----+------------+
|2    |300         |
+-----+------------+

result:

+-+---+
|1|500|
+-+---+
|2|300|
+-+---+

Then it would because there are two empid 1’s to sum together. Not sure if this explanation helps or not, but I hope it makes things a little clearer.

More Related Contents:

  1. How to create a specific SQL Server stored procedure? [closed]
  2. How to find the common values from two different tables having a common column
  3. Should I use != or for not equal in T-SQL?
  4. Any downsides of using data type “text” for storing strings?
  5. Can I pass column name as input parameter in SQL stored Procedure
  6. Foreign Key to non-primary key
  7. Difference between left join and right join in SQL Server [duplicate]
  8. Query for array elements inside JSON type
  9. Calculating Cumulative Sum in PostgreSQL
  10. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  11. How to create composite primary key in SQL Server 2008
  12. MySQL not using indexes with WHERE IN clause?
  13. Way to try multiple SELECTs till a result is available?
  14. Rename column SQL Server 2008
  15. Disable Rails SQL logging in console
  16. Easiest way to populate a temp table with dates between and including 2 date parameters
  17. IF EXISTS condition not working with PLSQL
  18. Using pivot on multiple columns of an Oracle row
  19. PostgreSQL wildcard LIKE for any of a list of words
  20. Max length for client ip address [duplicate]
  21. Use SELECT inside an UPDATE query
  22. How to query a CLOB column in Oracle
  23. passing SQL “IN” parameter list in jasperreport
  24. Using a database table as a queue
  25. Should I commit or rollback a read transaction?
  26. Exporting a CLOB to a text file using Oracle SQL Developer
  27. Row Rank in a MySQL View
  28. Select Rows with Maximum Column Value group by Another Column
  29. Can’t create stored procedure with table output parameter
  30. Is there a postgres CLOSEST operator?

Leave a Comment