问一个简单sql语句

[dinoLgrace]

select ITEM_NAME,CHARGES-PAYMENT,sum(CHARGES-PAYMENT) from m_zhixingkeshi
where DEPT_NAME='"+Convert.ToString(reader.GetValue(0))+"'
and PRINT_DATE>='"+TextBox1.Text+" 00:00:00' and PRINT_DATE<='"+TextBox2.Text+" 23:59:59'

提示出错：说甚么ITEM_NAME不是聚合语句也没有group by语句，请问怎么修改呢？

[marysxj]

while(reader1.Read())
{
Response.Write("<td align='center' colspan='2'>"+reader1.GetValue(0).ToString()+"</td>");
Response.Write("<td align='center' colspan='2'>"+reader1.GetValue(1).ToString()+"</td>");
Response.Write("<tr height='25'>");
Response.Write("<td align='center' border='0' style='border-collapse:collapse' colspan='2'></td>");
}

Response.Write("<tr height='25'>");
Response.Write("<td align='right' colspan='13'>"+reader.GetValue(0).ToString()+"优惠总金额："+reader1.GetValue(2).ToString()+"￥</td>");

－－－－－－－－－－－－－－－－－－
这事什么意思啊？

[LouisXIV]

select ITEM_NAME,CHARGES-PAYMENT,sum(CHARGES-PAYMENT) from m_zhixingkeshi
where DEPT_NAME='"+Convert.ToString(reader.GetValue(0))+"'
and PRINT_DATE>='"+TextBox1.Text+" 00:00:00' and PRINT_DATE<='"+TextBox2.Text+" 23:59:59'
group by ITEM_NAME,CHARGES-PAYMENT

[buer]

select ITEM_NAME,CHARGES-PAYMENT,sum(CHARGES-PAYMENT) from m_zhixingkeshi
where DEPT_NAME='"+Convert.ToString(reader.GetValue(0))+"'
and PRINT_DATE>='"+TextBox1.Text+" 00:00:00' and PRINT_DATE<='"+TextBox2.Text+" 23:59:59' group by ITEM_NAME,CHARGES-PAYMENT

[marysxj]

楼上正解！
含有sum等的聚合函数需要group by 才行哦！

[mapserver]

sql语句的语法有问题。
如果要select ITEM_NAME,CHARGES-PAYMENT，必须要group。

select ITEM_NAME,sum(CHARGES-PAYMENT) from m_zhixingkeshi
where DEPT_NAME='"+Convert.ToString(reader.GetValue(0))+"'
and PRINT_DATE>='"+TextBox1.Text+" 00:00:00' and PRINT_DATE<='"+TextBox2.Text+" 23:59:59' group by ITEM_NAME

[wudemingsunny]

含有sum等的聚合函数需要group by 才行哦！

[dinoLgrace]

但是我加了group by ITEM_NAME,CHARGES-PAYMENT后出现了这个错误：
在没有任何数据时进行无效的读取尝试？？？

[sanlng]

你是不是使用的是DataReader?出现这种情况的原因要不就是根本没有符合条件的记录,要不就是已经读到数据集的尾部了而你还在读.

[dinoLgrace]

while(reader1.Read())
{
Response.Write("<td align='center' colspan='2'>"+reader1.GetValue(0).ToString()+"</td>");
Response.Write("<td align='center' colspan='2'>"+reader1.GetValue(1).ToString()+"</td>");
Response.Write("<tr height='25'>");
Response.Write("<td align='center' border='0' style='border-collapse:collapse' colspan='2'></td>");
}

Response.Write("<tr height='25'>");
Response.Write("<td align='right' colspan='13'>"+reader.GetValue(0).ToString()+"优惠总金额："+reader1.GetValue(2).ToString()+"￥</td>");



我的语句这样的，如果出现这样的问题怎么解决呢？谢谢

[criedshy]

select ITEM_NAME,CHARGES-PAYMENT,sum(CHARGES-PAYMENT) from m_zhixingkeshi
where DEPT_NAME='"+Convert.ToString(reader.GetValue(0))+"'
and PRINT_DATE>='"+TextBox1.Text+" 00:00:00' and PRINT_DATE<='"+TextBox2.Text+" 23:59:59'
group by ITEM_NAME