怎么不能??????? select top 10 * ,总分=sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) from 成绩 group by 学生 order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc
select top 10 *,sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩)as 总分 from 成绩 group by * order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc为什么也不行, 应怎么改?
select top 10 t.*, s.总分 from tab1 t inner join (select sum(r.中文成绩+r.英文成绩+r.数学成绩+r.物理成绩+r.化学成绩) as 总分 from tab1 l join tab1 r group by 学生) s order by 总分 desc
select top 10 *,中文成绩+英文成绩+数学成绩+物理成绩+化学成绩 as 总分 from 成绩 order by 总分 desc
You should do it as follows:select top 10 *,sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩)as 总分 from 成绩 order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc
select top 10 * ,总分=sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩)
from 成绩 group by 学生 order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc
from 成绩
group by *
order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc为什么也不行, 应怎么改?
from tab1 t inner join
(select sum(r.中文成绩+r.英文成绩+r.数学成绩+r.物理成绩+r.化学成绩) as 总分
from tab1 l join tab1 r
group by 学生) s
order by 总分 desc
from 成绩
order by 总分 desc
from 成绩
order by sum(中文成绩+英文成绩+数学成绩+物理成绩+化学成绩) desc