sql统计问题！
sql代码如下：
select dictcharge.no1 as no1 ,
dictcharge.name1 as name1,
patinfo.hospcode,
sum(hosp_detail_price.price) as price
from dictcharge, his_history..hosp_detail_price hosp_detail_price, dictmedi , his_history..patinfo patinfo
where dictmedi.mediid = hosp_detail_price.mediid
and dictcharge.chargeid = dictmedi.hosptype
and hosp_detail_price.hospid = patinfo.hospid
and hosp_detail_price.isprice = 1
and hosp_detail_price.ischeck = 1
and hosp_detail_price.isconfirm = 1
and hosp_detail_price.ispay <> 1
and dictcharge.name1 = '手术费'
group by dictcharge.no1, patinfo.hospcode,dictcharge.name1 ;
查询结果如下：
25 手术费 20090001 700.00
25 手术费 20090003 300.00
25 手术费 20090004 400.00
25 手术费 20090005 600.00
25 手术费 20090009 1030.00
25 手术费 20090011 980.00
25 手术费 20090012 780.00
25 手术费 20090013 460.00
25 手术费 20090016 600.00
我想统计上面sql语句查询结果的行数，请高手指点。
SQL code:
select COUNT(*) as 行数
from (
select dictcharge.no1 as no1 ,
dictcharge.name1 as name1,
patinfo.hospcode,
sum(hosp_detail_pri
相关问答：
我有一个表，结构是这样。
转出 单位 转入单位 笔数 金额
date(主) outid(主) inid(主) num amt
2009 1 2 1 500 为 1 单位 在2009� ......
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式
XML code:
<folder state="unchecked" label="全部">
<folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
现在有两张表：文章主表A(articleId,articleTitle)，文章评论表B(commentId,articleId,commentTitle)
现在我想实现这样的功能：列出文章列表，其中每篇文章标题下面列出此文章的前2个文章评论，请问sql语句怎么写啊 ......
