MySQL Aggregate Functions without GROUP BY clause

by

It’s by design – it’s one of many extensions to the standard that MySQL permits.

For a query like SELECT name, MAX(age) FROM t; the reference docs says that:

Without GROUP BY, there is a single group and it is indeterminate
which name value to choose for the group

See the documentation on group by handling for more information.

The setting ONLY_FULL_GROUP_BY controls this behavior, see 5.1.7 Server SQL Modes enabling this would disallow a query with an aggregate function lacking a group by statement and it’s enabled by default from MySQL version 5.7.5.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. Does SQL Server Offer Anything Like MySQL’s ON DUPLICATE KEY UPDATE
  6. Storing JSON in database vs. having a new column for each key
  7. MySQL LIMIT clause equivalent for SQL SERVER
  8. SQL: Repeat a result row multiple times, and number the rows
  9. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  10. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  11. Is there a Profiler equivalent for MySql? [closed]
  12. Why do results from a SQL query not come back in the order I expect?
  13. Best practices for SQL varchar column length [closed]
  14. Relationship between catalog, schema, user, and database instance
  15. Import MySQL database into a SQL Server
  16. How to export data from SQL Server 2005 to MySQL [closed]
  17. What resources exist for Database performance-tuning? [closed]
  18. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  19. How to migrate SQL Server database to MySQL? [closed]
  20. how to cast the hexadecimal to varchar(datetime)?
  21. How to write a (MySQL) “LIMIT” in SQL Server?
  22. sql group by versus distinct
  23. How to import a SQL Server .bak file into MySQL?
  24. MySQL – Meaning of “PRIMARY KEY”, “UNIQUE KEY” and “KEY” when used together while creating a table
  25. Equivalent of MSSQL IDENTITY Column in MySQL
  26. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  27. What are the max number of allowable parameters per database provider type?
  28. Why in SQL NULL can’t match with NULL?
  29. Convert SQL Server query to MySQL [duplicate]
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment