select IDENTITY(int,1,1) as id,stu_id,sum(score) as score into #Temp from tablename group by stu_id order by sum(score) desc
select distinct 分数 order by 分数 desc
select distinct 分数 order by 分数 desc 看楼上多精辟
to:zxhong(红透半边天) 请问你的select IDENTITY(int,1,1) as id,stu_id,sum(score) as score into #Temp from tablename group by stu_id order by sum(score) desc 是什么意思!! 水平有限实在看不懂 请给个明确的注释!! 不胜感激!!
select IDENTITY(int,1,1) as id,stu_id,sum(score) as score into #Temp from tablename group by stu_id order by sum(score) desc 没错
看楼上多精辟
请问你的select IDENTITY(int,1,1) as id,stu_id,sum(score) as score into #Temp from tablename group by stu_id order by sum(score) desc
是什么意思!!
水平有限实在看不懂
请给个明确的注释!!
不胜感激!!
没错