Question

关于数据库不是单组分组函数的问题，求oracle牛人帮忙啊！！

select sum(a.price),
sum(a.tksum),
count(*),
(select count(*) from artificialtickets b where b.tkstatusid = 2)
from artificialtickets a
where a.operid = 199
and a.tktpyeid = 2
and a.drvdate = to_date('2011-10-31', 'yyyy-mm-dd');
都是同张表 那子查询 我是想再查比下面多了个约束条件的统计，但是这样就报：不是单组分组函数！可有什么办法解决吗，我是想在同一条语句中的！

Answer 1

select * from(
select sum(a.price),
sum(a.tksum),
count(*)
from artificialtickets a
where a.operid = 199
and a.tktpyeid = 2
and a.drvdate = to_date('2011-10-31', 'yyyy-mm-dd')),
(select count(*) from artificialtickets b where b.tkstatusid = 2)
我理解的意思就是你还是要查到一行 移到下面就行了

追问

这个可行，不过下面的还是要有外层的查询条件的，需要再加上！
刚刚请教了下别人，稍作改动可行！
select sum(.),
sum(.),
count(*),
count((select count(*) from artificialtickets b where b.tkstatusid = 2)) //此处套个函数，max(),min()什么的都可以
from artificialtickets a
where a.operid = 199
and a.tktpyeid = 1
and a.drvdate = to_date('2011-10-31', 'yyyy-mm-dd');

Answer 2

group by

追问

能详细点吗？我这个不是分组统计！