select count(*) from
(
SELECT field1
FROM tablename
GROUP BY field1
HAVING (SUM(field2) <> 0) OR (SUM(field3) <> 0) OR (SUM(field4) <> 0)
) a
(
SELECT field1
FROM tablename
GROUP BY field1
HAVING (SUM(field2) <> 0) OR (SUM(field3) <> 0) OR (SUM(field4) <> 0)
) a
解决方案 »
- 事务处理日志
- 怎样在查询分析器中改变连接到的数据库?
- mySQL中的数据导入SQL server 2005
- sql语句的生成问题
- 各位大佬,问下数据库在查询的时候是inner join 快还是left join快
- 请参与“上班一个月内碰到两个诡异的事务问题[500分求救]”者过来接分,版主请留情[4]
- 条件触发器问题?
- SQL server字段设置问题。getdata()
- 从一个数据表中读取某一字段的所有数据,譬如说共有3个数据,我现在想做的是针对于这8个数据中的每一行数据,我都用一个别名来表示,例如select ss.top1 as A,ss.top2 as B,ss.top3 as C from table;其中ss为
- 使用链接服务器时发生MSDAORA无法启动分布式服务是怎么回事?请高手指点!
- 巨难的转换~!!!!
- 求PI程序,速度奇慢
FROM tablename
group by field1
having sum(field2)<>0 OR SUM(field3) <> 0 OR SUM(field4) <> 0
SELECT field1
FROM tablename
group by field1
having sum(field2)<>0 OR SUM(field3) <> 0 OR SUM(field4) <> 0
)a
from (
SELECT field1
FROM tablename
group by field1
having sum(field2)<>0 OR SUM(field3) <> 0 OR SUM(field4) <> 0
)a