Hi,
I have a Rating table in my SQL database and I would like to return the
row containing the highest average rating where the picture_id for that
row is a certain value. I could do this by SQL but I’d like to use the
Ruby functions if it’s possible.
I can get the maximum value of rating like this:
@rating = Rating.maximum(:rating, :conditions => [‘picture_id = ?’,
@picture_id])
which works great but only returns the maximum value for the column
“rating” when I want the whole row of values for the record with the
maximum rating.
The SQL would be something like this:
SELECT user_id, picture_id, max(rating) FROM ratings WHERE picture_id =
? GROUP BY user_id, picture_id’, @picture_id]
I’ve not tested that but you get the idea…
So is there anyway of running the above SQL using a ruby function ?
Thanks for any help
Phil