2008年3月8日
T-SQL中计算排名问题（考试成绩视图）
SELECT [User_ID], [Exam_Id], [Score], [TotalScore], [Cnt], (select count(t.Score) from (Select Distinct Score From V_ExamStat) t Where t .Score>=V_ExamStat.Score) AS '全表排名', (select count(t2.Score) fr... Read More
posted @ 2008-03-08 12:00 blueKnight Views(660) Comments(0) Diggs(0)