SQL Server 总结复习，学习sqlserver的朋友可以参考下

1. 排名函数与PARTITION BY 代码如下: –所有数据 SELECT * FROM dbo.student AS a INNER JOIN dbo.ScoreTB AS b ON a.Id = b.stuid WHERE scorename = ‘语文’ ——————————————- –ROW_NUMBER() 的使用 生成列从1开始依次增加 ——————————————- SELECT ROW_NUMBER() OVER (ORDER BY B.SCORE DESC) AS RO