求教,取出某年级某课程第几名的成绩是多少?

[guhguh]

成绩表

学号 年级 课程1 课程2
1 3 90 89
2 4 79 59

[lynx1111]

select top 1 * from (select top 3 * from table3 where 年级=3 order by 课程1)a order by 课程1 desc

[wansijei]

这只能求出第一条。。如果要求第二条呢？？

[ylg007]

select * from where 课程1=(select top3 课程1 from tablename where 年级=3 group by 课程1)

[hjb111]

create proc P_GradeCourseMC @Grade as int,@Course as varchar(25),@MC as int
--创建一个存储过程@GRADE年级，@Course课程,@MC名次
as
select identity(int,1,1) idd,* into #t from 成绩表 order by @Course Desc
select * from #t where idd=@MC and 年级=@Grade --查询某年级某课程的第几名的记录
drop table #t
Go

调用此存储过程

exec('P_GradeCourseMC 1,'课程1',2')