105 views
Problem : I want to select a maximum avg for each cname in my table. SELECT cname, wmname, MAX(avg) FROM makerar GROUP BY cname; But I will get the below error, ERROR: column "makerar.wmname" must appear in the GROUP BY clause or be used in an aggregate ... ) FROM makerar GROUP BY cname; How can I go about fixing above error? Note: This table is the VIEW created from the previous operation.
asked
Jan 22, 2020
jwilliam
3.9k points