How does GROUP BY work?

by

GROUP BY returns a single row for each unique combination of the GROUP BY fields. So in your example, every distinct combination of (a1, a2) occurring in rows of Tab1 results in a row in the query representing the group of rows with the given combination of group by field values . Aggregate functions like SUM() are computed over the members of each group.

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. I want to find out how much zero come after 1 in SQL
  3. Update statement with inner join on Oracle
  4. Splitting string into multiple rows in Oracle
  5. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  6. How to use the ‘as’ keyword to alias a table in Oracle?
  7. Can a foreign key be NULL and/or duplicate?
  8. What is the string concatenation operator in Oracle?
  9. Using an Alias in a WHERE clause
  10. How can I introduce multiple conditions in LIKE operator?
  11. Is there any boolean type in Oracle databases?
  12. Stored Procedure with optional “WHERE” parameters
  13. How to use Oracle ORDER BY and ROWNUM correctly?
  14. How to Select a substring in Oracle SQL up to a specific character?
  15. passing table and column name dynamically using bind variables
  16. Conditional SUM on Oracle
  17. ORA 00904 Error:Invalid Identifier
  18. Deferrable Constraints in SQL Server
  19. Nth max salary in Oracle
  20. What does the colon sign “:” do in a SQL query?
  21. How do I get textual contents from BLOB in Oracle SQL
  22. SQL not displaying null values on a not equals query?
  23. Oracle query to match all values in the list among all rows in table
  24. Inserting into Oracle and retrieving the generated sequence ID
  25. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  26. Connecting to Oracle Database using Sql Server Integration Services
  27. Retrieve Oracle last inserted IDENTITY
  28. ORA-00933: SQL command not properly ended
  29. Update a table with data from another table
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment