leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

0178.sql (138B)


0 SELECT S.Score, count(DISTINCT t.score) AS 'rank'
1 FROM Scores S
2 JOIN Scores T
3 ON S.Score <= T.score
4 GROUP BY S.Id
5 ORDER BY S.Score DESC