Search SSWUG.ORG:



DATABASES

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