SELECT SUM(B.SCORE1), SUM(B.SCORE2),
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
解决方案 »
- oracle索引
- 关于空格和数字拼串后空格丢失的问题,请高手释疑。
- 如何写求季度累计求和SQL语句
- 问个to_char to_date的问题~~
- NO_DATA_FOUND.Exception 如何触发?
- Oracle中如何知道一个表占空间的大小?以及如何估算插入N条纪录后(最好纪录包括BLOB),占空间的大小?
- 出现错误:Ora:01041内部错误,HostDef扩展名不存在!什么原因,如何解决??
- application server???
- 我做了oracle系统,可是当我输入日文入数据库的时候出错
- insert语句和select语句连接问题
- imp80时oracle提示的错误(在win2000p下)
- 关于oracle9i分配空间的命令行如何写?
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME,B.NUM
SELECT SUM(B.SCORE1), SUM(B.SCORE2), A.NAME,
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME
这样也还是抱错啊
B.NUM FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY A.NAME,B.NUM谢谢大家 :)
SELECT SUM(B.SCORE1), SUM(B.SCORE2),
B.NUM,A.NAME FROM MASTER A, STUDENT B
WHERE A.ID = B.NUM AND B.SEX = '1' AND B.CLASS= '0001' GROUP BY B.NUM
这样可以吗,希望楼主能告知试验结果。