MySQL Forums
Forum List  »  Perl

Advanced Search
New Topic

Re: Problem with Order By and Group By
Posted by: Paulo Renato
Date: April 02, 2006 08:31PM

SELECT AVG(rating) as average
FROM ratings
WHERE db = 'maps'
GROUP BY db,ID_item
HAVING AVG(rating)
ORDER BY AVG(rating) ASC



Edited 2 time(s). Last edit at 04/02/2006 08:32PM by Yusuke Urameshi.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Problem with Order By and Group By
Paulo Renato
April 02, 2006 11:41AM
Re: Problem with Order By and Group By
Bob Field
April 02, 2006 01:26PM
Re: Problem with Order By and Group By
Paulo Renato
April 02, 2006 08:03PM
Re: Problem with Order By and Group By
Bob Field
April 02, 2006 08:19PM
Re: Problem with Order By and Group By
Paulo Renato
April 02, 2006 08:31PM
Re: Problem with Order By and Group By
Bob Field
April 02, 2006 09:19PM
Re: Problem with Order By and Group By
Paulo Renato
April 02, 2006 11:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.