sql - 是否可以在有子句中检查两个以上的条件？

Question

当我尝试以下查询时

select column2 
from table1 
group by column2 
having count(column3) = count(column1) and column5 in (1,2)

我收到此错误:

ORA-00979: not a GROUP BY expression
00979. 00000 -  "not a GROUP BY expression"

我应该写什么才能得到结果，即满足两个条件的 column2

即(count(column3) = count(column1) and column5 in (5,6).

Answer 1

试试这个:

select column2
from table1
where column5 in (1,2)
group by column2
having count(column3) = count(column1)