Breaking News: Grepper is joining You.com. Read the official announcement!

ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function

Pleasant Panda answered on September 20, 2021 Popularity 1/10 Helpfulness 1/10

answer ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function

ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function

Comment

SELECT m.cname, m.wmname, t.mx
FROM (
    SELECT cname, MAX(avg) AS mx
    FROM makerar
    GROUP BY cname
    ) t JOIN makerar m ON m.cname = t.cname AND t.mx = m.avg
;

 cname  | wmname |          mx           
--------+--------+------------------------
 canada | zoro   |     2.0000000000000000
 spain  | usopp  |     5.0000000000000000

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: aggregate clause function group-by sql

Link to this answer
Share Copy Link