sql:select a1, a2, a3, sum(a4) as s, (select sum(x) from xxxxxx .......................) as x
from tab
group by a1, a2, a3现在我想在后面加一句:having (两个sum不等), 请问该怎么写方便,因为x列很长很长,不想写sum(a4) <> (select sum(x) from xxxxxx .......................),可以用类似group by 1 2...等等的指代方法?另: 如果我写全了,sql会不会把(select sum(x) from xxxxxx .......................)执行两遍啊?
from tab
group by a1, a2, a3现在我想在后面加一句:having (两个sum不等), 请问该怎么写方便,因为x列很长很长,不想写sum(a4) <> (select sum(x) from xxxxxx .......................),可以用类似group by 1 2...等等的指代方法?另: 如果我写全了,sql会不会把(select sum(x) from xxxxxx .......................)执行两遍啊?
select a1, a2, a3, sum(a4) as s, (select sum(x) from xxxxxx .......................) as x
from tab
group by a1, a2, a3)m where s<>v--这样既可,没必要去加having