MySQL, GROUP BY, Select lists, and Standard SQL

(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 More - Register for Free Membership