Live briefing
Everything about Group by (SQL)
SQL clause
A GROUP BY clause in SQL specifies that a SQL SELECT statement partitions result rows into groups, based on their values in one or several columns. Typically, grouping is used to apply some sort of aggregate function for each group. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Group by (SQL)A 5-minute orientation
- Pick up a classic book: The little SAS bookThe most-reprinted book on the subject
- Go sideways: Select (SQL)A closely related topic
- Go sideways: SQL syntaxA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
- No matching papers found.
📚 Books worth reading
The little SAS bookLora D. Delwiche, Susan J. Slaughter · 1995
Learning PHP, MySQL & JavaScriptRobin Nixon · 2009
Access database design & programmingSteven Roman · 1997
Introduction to Computing Using PythonLjubomir Perkovic · 2011- 📕Database Modeling Step by StepGavin Powell · 2019
Data science from scratchJoel Grus · 2015
Introduction to Constraint DatabasesPeter Revesz · 2002
Intelligent Science and Intelligent Data EngineeringJian Yang · 2013
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Select (SQL) The SQL SELECT statement returns a result set of rows, from one or more tables. A SELECT statement retrieves zero or more rows from one or more database…
- SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…
- Having (SQL) A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows where aggregate values meet the specified conditions. HAVING and WHERE…
- Pivot table A pivot table is a table of values which are aggregations of groups of individual values from a more extensive table (such as from a database, spreadsheet…
- Window function (SQL) In SQL, a window function or analytic function is a function which uses values from one or multiple rows to return a value for each row. (This contrasts…
- Null (SQL) In the SQL database query language, null or NULL is a special marker used to indicate that a data value does not exist in the database. Introduced by the…
- Join (SQL) A join clause in the Structured Query Language (SQL) combines columns from one or more tables into a new table. The operation corresponds to a join operation…
- Relational algebra In database theory, relational algebra is a theory that uses algebraic structures for modeling data and defining queries on it with well founded semantics…