17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT sum(DECODE(SEX,'女',1,0)) 女生人数,sum(case when age>20 then 1 else 0 end) 超龄人数 FROM STUDENT
update T t
set result=
(
select a||b from (
(select count(*) as a from student where sex='女' and t.age = student.age),
(select count(*) as b from student where sex='女')
)
)