第3章++sql+语言基础(17)

3.2 变量例：显示选修课程成绩最高的学生的学号和成绩 declare @studentid char(8), @maxscore numeric(9) set @maxscore=(select max(grade) from sc ) set @studentid=(select sno from sc where grade=@maxscore) Select @studentid ‘学号’ ,@ maxscore’最高成绩’

2013-12-8