MySQL, GROUP BY, Select lists, and Standard SQL This is an off-site link.  Please review our Terms of Service for additional information.

(Peter Gulutzan) The MySQL manual says: "In standard SQL, a query that includes a GROUP BY clause cannot refer to nonaggregated columns in the select list that are not named in the GROUP BY clause."

Read this article...

comments powered by Disqus