select class from (
select class,sum(decode(sex),'M',1,0) Male,sum(decode(sex),'F',1,0) Female from schools group by class)
where Male=Female;
select class,sum(decode(sex),'M',1,0) Male,sum(decode(sex),'F',1,0) Female from schools group by class)
where Male=Female;
解决方案 »
- 表名带=号.....求打开,求指点....
- oracle主键加一个大于0的约束怎么加?
- Oracle 11g 安装问题
- oracle10g EX版本,ORA-12154: TNS: 无法解析指定的连接标识符
- oracle 什么时候会抛出-1 ----在线等待
- 可否动态执行存储过程
- oracle 密码忘了,怎么办
- clob,blob,pfile分别是什么?做什么用的?大概讲讲就行
- windows xp下oracle 8.16的listen无法启动,请各位帮帮忙
- Oracle9i安装问题!送100分!
- 哪儿有oracle的中文函数和语法帮助手册?(GG JJ DD MM发一份给我)
- 关于时间序列,请问错在哪里?
so the data type of field sex can be changed into CHAR(1).
select class,case when sex='M' then count(sex) end male,
case when sex='F' then count(sex) end female
from schools group by class,sex)
group by class having sum(male)=sum(female);
select class,sum(decode(sex,'M',1,0)) Male,sum(decode(sex,'F',1,0)) Female from schools
group by class)
where Male=Female;