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

mysql error of SELECT list is not in GROUP BY clause

Odd Orangutan answered on November 25, 2020 Popularity 3/10 Helpfulness 1/10

answer mysql error of SELECT list is not in GROUP BY clause

related select list is not in group by clause

mysql error of SELECT list is not in GROUP BY clause

Comment

SELECT t2.hacker_id, t1.name, COUNT(t2.challenge_id) AS challenges
FROM Hackers t1
JOIN Challenges t2 on t1.hacker_id = t2.hacker_id
GROUP BY 1, 2
HAVING challenges IN 
    (SELECT MAX(chal_count) FROM
    (SELECT COUNT(challenge_id) AS chal_count FROM Challenges
    GROUP BY hacker_id) AS t3)
    OR challenges IN
    (SELECT chal_count FROM
    (SELECT COUNT(challenge_id) AS chal_count FROM Challenges
    GROUP BY hacker_id) AS t4 
    GROUP BY 1 HAVING COUNT(chal_count) = 1)
ORDER BY 3 DESC, 1;

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: clause group-by list mysql select sql

Link to this answer
Share Copy Link

Contributed on Aug 26 2022

Odd Orangutan

0 Answers Avg Quality 2/10

Closely Related Answers

select list is not in group by clause

Comment

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

Popularity 10/10 Helpfulness 10/10 Language sql

Source: stackoverflow.com

Tags: clause cl

Link to this answer
Share Copy Link

Contributed on Nov 25 2020

Worrisome Wallaby

0 Answers Avg Quality 2/10

mysql error of SELECT list is not in GROUP BY clause

Contents

More Related Answers

mysql error of SELECT list is not in GROUP BY clause

Closely Related Answers

select list is not in group by clause

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.