select sum(decode(vconn, 'sk', 1, 0)) sk, sum(decode(vconn, 'lg', 1, 0)) lg, sum(decode(vconn, 'ktf', 1, 0)) ktf from A
顺序反了 应该是 select sum(decode(vconn, 'sk', 1, 0)) sk, sum(decode(vconn, 'ktf', 1, 0)) ktf, sum(decode(vconn, 'lg', 1, 0)) lg from A
select (select count(*) from A where conn='sk') as sk, (select count(*) from A where conn='lg') as lg, (select count(*) from A where conn='ktf') as ktf from A也行
sum(decode(vconn, 'lg', 1, 0)) lg,
sum(decode(vconn, 'ktf', 1, 0)) ktf
from A
应该是
select sum(decode(vconn, 'sk', 1, 0)) sk,
sum(decode(vconn, 'ktf', 1, 0)) ktf,
sum(decode(vconn, 'lg', 1, 0)) lg
from A
(select count(*) from A where conn='lg') as lg,
(select count(*) from A where conn='ktf') as ktf
from A也行