sql面试练习题
sql语句:
SELECT * into #t from ( select B.sid,A.name,b.score from student A,Score B
WHERE A.id=b.sid group by b.sid,a.name,b.score)k
select * from (
select DISTINCT M.name,SUM(score) over(order by sid) as TotalScore from #T as M
) A order by a.TotalScore desc
DROP TABLE #T