统计问题请教

Question

select uname,pass,count(*) 
grouping(t1.uname) 人名次数,
grouping(t1.pass)  通过次数
from
t1,t2
where t1.uname=t2.username
and t2.username in (...)
rollup(uname,pass)
having grouping(t1.uname)=1 
or
having grouping(t1.pass)=1

Answer 1

select uname,pass,count(*),        /////掉了,号
grouping(t1.uname) 人名次数,
grouping(t1.pass)  通过次数
from
t1,t2
where t1.uname=t2.username
and t2.username in (...)
rollup(uname,pass)
having grouping(t1.uname)=1 
or
having grouping(t1.pass)=1

Answer 2

select t2.name,count(t1.name),count(decode(sign(pass),1,1,0))from t1, t2 where t1.name(+)=t2.name group by t2.name

Answer 3

select t2.name,count(t1.name),sum(decode(sign(pass),1,1,0))from t1, t2 where t1.name(+)=t2.name group by t2.name

Answer 4

使用sum 才可得，不好意思

Answer 5

select t1.name,count(1),sum(decode(sign(pass),1,1,0)) from t1,t2 where t1.name=t2.name(+) group by t1.name