只想要行数,不要结果集,直接count就是了为什么还要产生结果集
解决方案 »
- 求 SQL2005中 用多关键字同时查询某个数据库语句 数据库中有符合关键字中任何一个的,列出来
- sql server 2005 竞然有个这么弱智的BUG???
- 请教一个sql语句?
- 求一个Sql的小函数....貌似不难的~~
- ASP程序的后台SQL Server数据很慢,常出如下错误:
- Sql 2000 在win2003 上安装出现的问题!
- 请问如何同步数据库?创建索引问题,高手请进。
- 如何用SQL语句复制表和表中的数据???急!!!
- 请问在sqlserver中如何使用操作系统的文件?如何读写文件?
- 求助 为什么2012 SSMS查询管理器中按F5会触发调试器?应该是运行sql啊
- 求救高手 SQL优化问题?
- 极难汇总问题
(
select a.caccount, cname, count_account=COUNT(*), sum_num=SUM(mnum), date_min=MIN(mdate), date_max=MAX(mdate), date_part=mdate
from bm_person AS a LEFT JOIN bm_account
AS b ON b.caccount=a.caccount
where (mdate BETWEEN '2005-1-1' AND '2005-11-1')
GROUP BY a.caccount, mdate, cname, cicnumber
HAVING SUM(mnum)>=5 and COUNT(*)>=6
) t
直接使用其作为子查询求count(*)即可.select count(*) from
(
select a.caccount, cname, count_account=COUNT(*), sum_num=SUM(mnum), date_min=MIN(mdate), date_max=MAX(mdate), date_part=mdate
from bm_person AS a LEFT JOIN bm_account
AS b ON b.caccount=a.caccount
where (mdate BETWEEN '2005-1-1' AND '2005-11-1')
GROUP BY a.caccount, mdate, cname, cicnumber
HAVING SUM(mnum)>=5 and COUNT(*)>=6
) t
SqlCommand.ExecuteNonQuery 方法
对连接执行 Transact-SQL 语句并返回受影响的行数。
执行的语句需要变成:
select count(*)
from(
select a.caccount, cname, count_account=COUNT(*), sum_num=SUM(mnum), date_min=MIN(mdate), date_max=MAX(mdate), date_part=mdate
from bm_person AS a LEFT JOIN bm_account
AS b ON b.caccount=a.caccount
where (mdate BETWEEN '2005-1-1' AND '2005-11-1')
GROUP BY a.caccount, mdate, cname, cicnumber
HAVING SUM(mnum)>=5 and COUNT(*)>=6
)a