求解应聘一个公司笔试的Sql题！！！

[jfei793]

表A(S#,C#,grand)其中S#为学号 C#为课程号 grand该学生对应课程的成绩
要求写出SQL语句查询结果为
1.按各科的平均成绩降序排列出各条记录，如有平均成绩相同的学科则，
相同成绩的记录按课程号升序排列。
2.以上再加上一条要求输出的记录平均成绩在80以上！

[sdhdy]

--应该是一条SQL语句的
select c#,avg(grand) 平均成绩 from 表A group by c# having avg(grand)>=80 order by avg(grand) desc,c#

[playyuer]

easy

[mfjun007]

按题意，应该可以这样：
1:select s#,c# ,avg(grand) from table group by c# order by avg(grand) desc,c#
2:select s#,c#,avg(grand) from table group by c# having avg(grand)>80 order by avg(grand) desc,c#

[bunnysky]

很Easy
写了这么多了，帮你顶一下吧!

[mnm0756]

都写了，不用我说了吧...

[devilwind]

感觉这个问题问的就有问题！

[donghb8]

支持:8LY8Apollo(阿波罗)
他的已经能够实现了

[hopeweb]

select s#,c#,grand from a
group by s#,c#,grand
having avg(grand)>80
order by avg(grand) desc

[hopeweb]

以上写了很多，但还没有真正完全符合题意的。包手括我的在内。关注中。

[spidertan]

up

[raymond323]

up

[jackiehua]

1.select avg(grade),c# from a group by c# order by 2

2.select avg(grade),c# from a group by c# having avg(grade)>=80 order by 2

[cloudchen]

这个做考题不太适合吧。。。

[hanwen]

1:select c# ,avg(grand) from A group by c# order by avg(grand) desc,c#
2:select c#,avg(grand) from A group by c# having avg(grand)>80 order by avg(grand) desc,c#
不合你的要求？？

[pwzhu666]

select c#,avg(grand) from table group by c# where avg(grand)>80 order by c# desc

[feeling_68]

1:select s#,c# ,avg(grand) from a group by c# order by avg(grand) desc,c# asc
2:select s#,c#,avg(grand) from a group by c# having avg(grand)>80 order by avg(grand) desc,c# asc

[erigido]

经典题目啊

[ghosthjt]

呵呵，简单的题目呀。

[new_life]

select C#,avg(grand) from Table1 order by 2 asc, 1 desc group by C#
select C#,avg(grand) from Table1 order by 2 asc, 1 desc group by C# having avg(grand)>80

[jfei793]

百家争鸣。我晕！