摘要：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
阅读全文
posted @ 2012-08-06 23:04
