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语句
- 如何把mssql 的数据库移植到oracle数据库中?
- 关于索引
- 大家帮忙,初学 PL SQL 应该看那些书或文档呢?
- 创建类型的时候SQL-Plus就死在那不动了,怎么回事??
- 先安装oracle8.17,这时oracle8.17一切正常,但是安装了PB8后就打不开oracle8.17的应用如:Net8 Configuration Assistant。鼠标闪烁后就
- select to_char(to_date(1234567,'j'),'Jsp') from dual;(整数转英文)
- 菜鸟的问题:为什么用SQL*PLUS编辑插入命令插入的记录在DBA STUDIO的表中显示不出来
- 能够实现这样的设想
- 如何用UTL_FILE.FOPEN打开客户端的文件?急!
- 哪位高人给优化一下这条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