Live briefing
Everything about Having (SQL)
SQL clause
A HAVING clause in SQL specifies that an SQL SELECT statement must only return rows where aggregate values meet the specified conditions. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Having (SQL)A 5-minute orientation
- Pick up a classic book: Invitation to Computer ScienceThe most-reprinted book on the subject
- Read the landmark paper: Prevention of SQL Injection Attacks having XML DatabaseCited 0 times
- Go sideways: Group by (SQL)A closely related topic
- Go sideways: Select (SQL)A closely related topic
🏆 Landmark papers (most cited)
📚 Books worth reading
Invitation to Computer ScienceG. Michael Schneider, Judith L. Gersting · 1995
Access database design & programmingSteven Roman · 1997
The Book of PostfixPatrick Koetter, Ralf Hildebrandt · 2005- 📕SMART ScriptingShiv Kiran · 2019
Expert PHP and MySQLAndrew Curioso · 2010
Pro EJB 3 - Java Persistence APIMIKE KEITH,MERRICK SCHINCARIOL · 2006
The Minimum You Need to Know about Logic to Work in ItRoland Hughes · 2007
Selected papers in network and system administrationAnderson, Eric, Burgess, Mark · 2002
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Group by (SQL) 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…
- 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…
- 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…
- 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…
- 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…
- Correlated subquery In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values…
- 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…
- Cursor (databases) In computer science, a database cursor is a mechanism that enables traversal over the records in a database. Cursors facilitate processing in conjunction…