Question: I am getting these errors for almost every script mysql > SELECT sku AS PRODUCT _ SKU, description AS PRODUCT _ DESCRIPTION, - > COUNT
I am getting these errors for almost every script
mysql SELECT sku AS PRODUCTSKU, description AS PRODUCTDESCRIPTION,
COUNT AS RETURNFREQUENCY
FROM Orders INNER JOIN RMA ON Orders.OrderID RMA.OrderID
GROUP BY PRODUCTSKU
ORDER BY RETURNFREQUENCY DESC;
ERROR : Expression # of SELECT list is not in GROUP BY clause and contains nonaggregated column 'QuantigrationUpdates.Orders.Description' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sqlmodeonlyfullgroupby
mysql SELECT COUNT AS RETURNEDAMOUNT,
Orders.SKU AS PRODUCTSKU,
Orders.Description AS PRODUCTDESCRIPTION
FROM Orders INNER JOIN RMA ON Orders.OrderID RMA.OrderID
GROUP BY PRODUCTSKU
ORDER BY RETURNEDAMOUNT DESC
LIMIT ;
ERROR : Expression # of SELECT list is not in GROUP BY clause and contains nonaggregated column 'QuantigrationUpdates.Orders.Description' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sqlmodeonlyfullgroupby
I am working on DAD Project
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
