点击打开链接
select (select count(*) from v where v.p = 1)/(select count(*) from v) from dual;
其他回答
select ((select count(*) from v where P='1')as p1/(select count(*) from v)as p)as s from v
郭哥之子
发布于2011-05-27 13:03
评论
0
0
select p,counta/countb from
(select p,count(*) counta, (select count(*) from v) countb from v group by p) c
(select p,count(*) counta, (select count(*) from v) countb from v group by p) c
mailking2001
发布于2011-05-27 10:49