查询学生的总成绩,并进行排名,总分重复时不保留名次空缺
这里主要学习一下使用变量。在SQL里面变量用@来标识。
set @crank=0;
select q.sid, total, @crank := @crank +1 as rank from(
select sc.sid, sum(sc.score) as total from sc
group by sc.sid
order by total desc)q;
查询学生的总成绩,并进行排名,总分重复时不保留名次空缺
这里主要学习一下使用变量。在SQL里面变量用@来标识。
set @crank=0;
select q.sid, total, @crank := @crank +1 as rank from(
select sc.sid, sum(sc.score) as total from sc
group by sc.sid
order by total desc)q;