34,593
社区成员
发帖
与我相关
我的任务
分享如何取得有 group by 的select 语句返回的记录条数？
比如：
select count(*) as countRec, A, B, C from table where A=9 group by A, B, C
需要获得它返回的记录条数
select count(*) as countRec, A, B, C from table where A=9 group by A, B, C
需要获得它返回的记录条数
...全文
请发表友善的回复…
发表回复
jilate 2004-12-09
- 打赏
- 举报
同意楼上的
WangZWang 2004-12-09
- 打赏
- 举报
select count(*) as [记录条数]
from (Select A, B, C from table where A=9 group by A, B, C) as tbl
from (Select A, B, C from table where A=9 group by A, B, C) as tbl
qyq1973 2004-12-09
- 打赏
- 举报
对是对，但是不和其它数据库兼容
jiang130 2004-12-09
- 打赏
- 举报
select count(*) from (select count(*) as countRec, A, B, C from table where A=9 group by A, B, C) as a
vinsonshen 2004-12-09
- 打赏
- 举报
Select A, B, C from table where A=9 group by A, B, C
print '记录数='+ cast(@@rowcount as varchar)
print '记录数='+ cast(@@rowcount as varchar)
