You are viewing a single comment's thread. Return to all comments →
MySQL query
(select hacker_id, challenge_id, max(score) as scr from submissions group by hacker_id, challenge_id) as temp left join hackers h on h.hacker_id=temp.hacker_id group by temp.hacker_id, h.name having total !=0 order by total desc, hacker_id asc
Seems like cookies are disabled on this browser, please enable them to open this website
Contest Leaderboard
You are viewing a single comment's thread. Return to all comments →
MySQL query