单车男

摘要： 1. 排名函数与PARTITION BYView Code --所有数据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.SCOR 阅读全文