select t.by_examine_person,
avg(t.self_score),
avg(t.profes_score),
t.examine_year
from examtrade t
where t.examine_year = '2005'
group by t.by_examine_person, t.examine_year;
avg(t.self_score),
avg(t.profes_score),
t.examine_year
from examtrade t
where t.examine_year = '2005'
group by t.by_examine_person, t.examine_year;
解决方案 »
- 书上有一句话,我无法理解,请帮忙指点!
- 关于统计的sql
- oracle 存储过程一直报调用接口出错:ORA-01422: 实际返回的行数超出请求的行数,请大侠们帮助下看哪里出问题了
- 多个Union all 语句 求优化
- 對表進行delete操作時速度慢
- java编写的过程要怎样才能在Oracle9i中成功运行?
- oracle数据库错误
- SQL Server TO Oracle 问题
- 一个简单但不常见的Select语句,谁会写?
- oracle数据迁移到sqlserver
- 哪位高人给优化一下这条sql 语句,指点一下如何优化也可以,谢谢
- 如何使用C#上传图片到ORACLE中,然后在需要的时候取出呢?谢谢(目前只有这么多分分勒,有了再加)
examine_year from examtrade group by by_examine_person,examine_year
by_examine_person,
sum(self_score) /count(distinct examine_person),
sum(profes_score)/count(distinct examine_person),
examine_year
from
examtrade
group by
by_examine_person,examine_year
http://blog.csdn.net/ezerg/archive/2004/12/07/208104.aspx
from(
select by_examine_person, examine_year,sum(self_score),sum(profes_score)
from examtrade group by by_examine_person,examine_year, examine_person)
group by by_examine_person,examine_year