leetcodeSolution 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