CODEWITHSUNDEEP
mysqlsql-order-by
max_
max_

Reputation: 24481

Reference to group function not supported

I am receiving the following error from the below query, as I am trying to order the results by a value being retrieved in the query itself. Please can you tell me how I can get around this error, I am guessing by creating a sub-query within the query, of which I don't know how to!

SELECT q.*, COUNT(DISTINCT a.qid) AS `a_count`
FROM `questions` AS q
INNER JOIN `answers` AS a
ON a.qid = q.id
ORDER BY MAX(a_count)
LIMIT 0, 10;

Upvotes: 0

Views: 4871

Answers (1)

Mitch Dempsey
Mitch Dempsey

Reputation: 39869

You can't ORDER BY MAX(a_count), as that doesn't make sense. (You can't really sort by a single value)

You probably wanted to do ORDER BY a_count.

Upvotes: 1

Related Questions