Reverse Result Set

[The Little Guy]

I have a query that looks like so:

 

select b.id, b.name, count(*) as ratings, sum((managers + difficulty + fun + hours + pay + flexibility) / 6) as total
from ratings r left join businesses b on(r.business_id = b.id) group by b.name order by total desc limit 10;

 

if I didn't have a limit this could return hundreds of rows, but everything that is returned is what I want, how can I reverse the result set?

 

Basically I want to have a "Top 10" page, that lists the top ten items, but instead of #1 being first, I want it to be last.

[fenway]

Well, you could just iterate through them backwards, or reverse() the recordset.  But if you use a subquery, you can re-order them in mysql, too.

[The Little Guy]

This works:

 

select * from (select b.id, b.name, count(*) as ratings, sum((managers + difficulty + fun + hours + pay + flexibility) / 6) as total
from ratings r left join businesses b on(r.business_id = b.id) group by b.name order by total desc limit 10) as tmp order by tmp.total;