Group By and Order By - Cacher Snippet

9/26/2014 - 11:34 AM

Group By and Order By

Group By and Order By

SELECT servants.id,  servants.nick, servants.status,rank.level, rank.name FROM servants
LEFT JOIN rank
on servants.rank_id = rank.level
GROUP BY rank.level, servants.nick
ORDER BY rank.level ASC,servants.status DESC