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