Why does MySQL allow “group by” queries WITHOUT aggregate functions?

by

According to this page (the 5.0 online manual), it’s for better performance and user convenience.

More Related Contents:

  1. In MySQL, should I quote numbers or not?
  2. What does SQL Select symbol || mean?
  3. Using LIMIT within GROUP BY to get N results per group?
  4. How to perform grouped ranking in MySQL
  5. Required to join 2 tables with their FKs in a 3rd table
  6. MySQL Trigger after update only if row has changed
  7. MySQL “WITH” clause
  8. Ordering by specific field value first
  9. MySQL “Group By” and “Order By”
  10. How to change the CHARACTER SET (and COLLATION) throughout a database?
  11. MySQL Query to select data from last week?
  12. The total number of locks exceeds the lock table size
  13. Mysql 1050 Error “Table already exists” when in fact, it does not
  14. Convert partially non-numeric text into number in MySQL query
  15. MySQL “IN” operator performance on (large?) number of values
  16. How to get the latest record in each group using GROUP BY? [duplicate]
  17. MySQL Select last 7 days
  18. SQL unique varchar case sensitivity question
  19. How do I count columns of a table
  20. Difference between two table structure
  21. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  22. How to retrieve JSON data from MySQL?
  23. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  24. Why MySQL is giving error “Not allowed to return a result set from a function”?
  25. When to use a left outer join?
  26. MySQL 5.6 – DENSE_RANK like functionality without Order By
  27. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. MySQL update statement to store ranking positions
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment