哪位大哥帮小弟解决哈问题

[henry14kidd5]

首先是查处平均成绩并降序排序，这一步小弟自己完成了，代码如下

select score.`学号`, AVG(score.`成绩`), student.`姓名`
from score, kecheng, student
where score.`课程编号`=kecheng.`课程编号` AND student.`学号`=score.`学号`
group by student.`姓名`
order by avg(score.`成绩`) desc

第二，就是查询自己按平均成绩排序的名次。这个该如何实现，哪位大哥帮哈小弟，万分感谢！！！！

[rucypli]

放到一张有自增列的表里

[ACMAIN_CHM]

select count(*)
from (
select `学号`,AVG(`成绩`) as a
from score
group by `学号`
) a 
where a.a>(select AVG(`成绩`) from score where `学号`='自己')

[WWWWA]

上述SQL语句存为VIEW
set @a=0;
select *,@a:=@a+1 as mc from (
select * from view order by view) a

[henry14kidd5]

如何将SQL语句存为View[Quote=引用 4 楼 wwwwa 的回复:]

上述SQL语句存为VIEW
set @a=0;
select *,@a:=@a+1 as mc from (
select * from view order by view) a
[/Quote]

[WWWWA]

create view view1 as SQL语句

[henry14kidd5]

但是插入不到表里去