求sql语句! 学生成绩表shcj字段: 学号xh,姓名xm,成绩cj,科目km求语文+数学+英语》200分的学生的学号姓名。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select xh,xmfrom (select xh,xm,sum(cj) zcjfrom shcjwhere km in(语文,数学,英语)group by xh,xm)where zcj>200; SELECT XH, XM FROM (SELECT XH, XM, SUM(CJ) SCJ FROM SHCJ WHERE KM IN ('语文', '数学', '英语') GROUP BY XH, XM) WHERE SCJ > 200; select xh,xm,sum(cj) zcj from shcj where km in('语文','数学','英语') group by xh,xm having sum(cj) >=200 select xh,xmfrom shcj where km in(语,数,英) group by xh,xmhaving sum(cj)>200;也行。看看哪种效率高些。 select xh,xmfrom shcj where km in('语文','数学','英语') group by xh,xm having sum(cj) >=200 SELECT xh,xm FROM shcj WHERE km IN('语文','数学','英语') GROUP BY xh,xm HAVING SUM(cj) >=200; SELECT XH,XM FROM SHCJ GROUP BY XH,XM HAVING SUM(DECODE(KM,'数学',CJ,'语文',CJ,'英语',CJ,0)) > 200; 执行完毕, 但带有警告 Oracle数据库 17003 无效的列索引 请教一个PLSQL过程编译问题 局域网里怎样连接远程的oracle数据库 使用pl/sql text importer功能 oracle 挂起,急 求pl/sql帮助文档 怎样在企业管理器中建库? ORA 报错 你谁知道在ASP中,ORACLE的数据库除了用UPDATE语句外,还有什么方法更新某字段的值 高分求救!如何解决回滚段太小问题?急,急,急,急! 关于日期比较问题(高分赠送)
from (
select xh,xm,sum(cj) zcj
from shcj
where km in(语文,数学,英语)
group by xh,xm
)
where zcj>200;
FROM (SELECT XH, XM, SUM(CJ) SCJ
FROM SHCJ
WHERE KM IN ('语文', '数学', '英语')
GROUP BY XH, XM)
WHERE SCJ > 200;
from shcj
where km in('语文','数学','英语')
group by xh,xm
having sum(cj) >=200
from shcj
where km in(语,数,英)
group by xh,xm
having sum(cj)>200;
也行。看看哪种效率高些。
from shcj
where km in('语文','数学','英语')
group by xh,xm
having sum(cj) >=200
SELECT XH,XM
FROM SHCJ
GROUP BY XH,XM
HAVING SUM(DECODE(KM,'数学',CJ,'语文',CJ,'英语',CJ,0)) > 200;