聊聊 SQL 中的排名问题
复制WITH t AS
(SELECT 1 StuID,70 Score
UNIONALL
SELECT 2,85
UNIONALL
SELECT 3,85
UNIONALL
SELECT 4,80
UNIONALL
SELECT 5,74
)
SELECT * INTO Scores FROM t;
SELECT * FROM Scores
1.2.3.4.5.6.7.8.9.10.11.12.13.
THE END
