Skip to content

Commit a0d2128

Browse files
the1Riddlethe1Riddle
authored
rank-scores.sql to rank-scores.tsql
1 parent 1036326 commit a0d2128

File tree

2 files changed

+6
-15
lines changed

2 files changed

+6
-15
lines changed

‎MySQL/rank-scores.sql

Lines changed: 0 additions & 15 deletions
This file was deleted.

‎MySQL/rank-scores.tsql

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
# Time: O(n^2)
2+
# Space: O(n)
3+
4+
/* Write your T-SQL query statement below */
5+
SELECT Score, DENSE_RANK() OVER(ORDER BY Score DESC) AS RANK FROM Scores;
6+

0 commit comments

Comments
 (0)