SELECT TOP 1 课程号 FROM TB GROUP BY 课程号 ORDER BY AVG(成绩) DESC
SELECT TOP 1 课程号 FROM TB GROUP BY 课程号 ORDER BY AVG(成绩) DESC
select top 1 课程号 from (select 课程号,avg(成绩) as 成绩 from tb group by 课程号)t order by t.成绩 desc
select top 1 课程号、sum(成绩) as 总成绩 from 选课表 group by 课程号 oder by 总成绩 DESC
SELECT 课程号 FROM (SELECT 课程号,AVG(成绩) '平均成绩' FROM TB GROUP BY 课程号) T1 WHERE NOT EXISTS( SELECT 1 FROM (SELECT 课程号,AVG(成绩) '平均成绩' FROM TB GROUP BY 课程号) T2 WHERE T2.课程号<>T1.课程号 AND T2.平均成绩>T1.平均成绩 )
;with f as ( select 课程号,avg(成绩) as 成绩 from tb group by 课程号 ) select 课程号 from(select id=row_number()over(order by 成绩 desc),* from f)t where id=1
select * from ( SELECT 课程号 ,AVG(成绩) b FROM TB GROUP BY 课程号 )t where b=(select max(B) from ( SELECT 课程号 ,AVG(成绩) b FROM TB GROUP BY 课程号 )t1 )
top 1 课程号
from
(select 课程号,avg(成绩) as 成绩 from tb group by 课程号)t
order by
t.成绩 desc
from 选课表
group by 课程号
oder by 总成绩 DESC
(SELECT 课程号,AVG(成绩) '平均成绩' FROM TB GROUP BY 课程号) T1
WHERE NOT EXISTS(
SELECT 1 FROM (SELECT 课程号,AVG(成绩) '平均成绩' FROM TB GROUP BY 课程号) T2
WHERE T2.课程号<>T1.课程号 AND T2.平均成绩>T1.平均成绩
)
(
select 课程号,avg(成绩) as 成绩 from tb group by 课程号
)
select 课程号 from(select id=row_number()over(order by 成绩 desc),* from f)t where id=1
(
SELECT 课程号 ,AVG(成绩) b FROM TB GROUP BY 课程号
)t where b=(select max(B) from (
SELECT 课程号 ,AVG(成绩) b FROM TB GROUP BY 课程号
)t1
)