跪求一个sql语句。
成绩表StuScore：课程名courseName、学号studNo、姓名name、成绩score
求全校每门课程考试成绩排名前三名的学生名单
输出 课程名 姓名 成绩
想了N久想不出来，求大虾们帮帮忙
SQL code:
select courseName,name,score
from StuScore a
where 3>=(select count(*) from tb where courseName=a.courseName and score>=a.score)
排名必然涉及到同分如何排的问题
SQL code:
select name from
(
select *,row_number() over(partition by courseName order by score desc) rank
from StuScore
)tt
where rank<=3
SQL code:
-sql2000
select name from
(
select *,
(select count(*) from StuScore where courseName=s.courseName and score<s.score) rank
from StuScore
) tt
where rank<=3
-sql2005
select name from
(
select *,row_number() over(partition by courseName order by score desc) rank
from StuScore
)tt
where rank<=3
select *
from StuScore ms
inner join
(
select courseName+score cs
from StuScore ss
where score > (select top 3 score from StuScore s1 where s1.CourseName = ss.CourseName)
) tmp
wh
相关问答：
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'亿'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
为什么上一个用varchar转换后就只保留了� ......
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式
XML code:
<folder state="unchecked" label="全部">
<folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
小弟，最近要转行去做oracle开发了，由于大学毕业时，走了个弯路，现在很小心，问下，做PL/SQL有没有前途？？？
当然我说的这个前途是指 以后要跳槽，市场对这样的人才的需求量大不大？？
3q 那看来还只能先接� ......
字段1,字段2.....字段N,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
想要的结果是:
1,Na ......
