我的写法SELECT Phone, ROUND(SUM(price), 2) AS price, type
FROM Bill
GROUP BY Phone, type我要这样的结果
怎么写啊,郁闷死了。
FROM Bill
GROUP BY Phone, type我要这样的结果
怎么写啊,郁闷死了。
解决方案 »
- 关于日期选择的问题
- web项目或者网站项目,怎么调用剪切板里的数据呢? Clipboard.GetDataObject()无效
- javascript与asp.net
- DataGrid关于显示数据的问题
- asp.net中如何将pdf文件显示到页面
- 关于读取数据库短信,并及时提示的问题
- Application pools资源回收的问题
- 新人提问,请问方法的参数有什么作用呢?这与直接在方法里定义变量有什么区别呢?
- 请问如何请SQL SERVER里的密码做隐藏或者加密码,目的是为了连空间商也不能从SQL SERVER查看得了密码
- 关于字段判断问题,在DataBider.Eval(Container.Dataitem,"字段")!请各为高手赐教!(急急!!在线等!!有高分!)
- coolite 和 extjs哪个更好
- 急求!!asp.net中两个数组如何把它们里面的元素进行比较!!!!!!!!!!!!!!!!!!!!!!!!!!
FROM Bill
GROUP BY Phone
Order by Phone
提示错误啊,type不在group也不在聚合函数
<HeaderTemplate>
<table >
<caption align="top" id="caption" runat="server">
<%Response.Write(Department.SelectedItem.ToString()); %>
</caption>
<tr width="2000px">
<td width="33% ">
分机号</td>
<td width="33% ">
价格</td>
<td width="33% ">
类型</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# Eval("Phone")%>
</td>
<td id="td1" runat="server">
<%# Eval("price")%>
</td>
<td id="td2" runat="server">
<%# Eval("type")%>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
非聚合列要出现在Group by子句
提个建议,你把创建表的SQL发出来,也方便别人测试
goldmantis数据备份传上去了
repeater 肯定要改的,如果就单单绑定字段的话,还要改select语句了。
哎,水平他差了。
只要表结构就行了或者随便加几条数据的SQL你数据库没保密信息吧?
SELECT Phone, ROUND(SUM(CASE typecode WHEN '0' THEN price ELSE 0 END), 2)
AS 't0', ROUND(SUM(CASE typecode WHEN '1' THEN price ELSE 0 END), 2) AS 't1',
ROUND(SUM(CASE typecode WHEN '2' THEN price ELSE 0 END), 2) AS 't2',
ROUND(SUM(CASE typecode WHEN '3' THEN price ELSE 0 END), 2) AS 't3',
ROUND(SUM(CASE typecode WHEN '4' THEN price ELSE 0 END), 2) AS 't4',
ROUND(SUM(CASE typecode WHEN '5' THEN price ELSE 0 END), 2) AS 't5',
ROUND(SUM(CASE typecode WHEN '6' THEN price ELSE 0 END), 2) AS 't6',
ROUND(SUM(CASE typecode WHEN '7' THEN price ELSE 0 END), 2) AS 't7',
ROUND(SUM(CASE typecode WHEN '8' THEN price ELSE 0 END), 2) AS 't8',
ROUND(SUM(CASE typecode WHEN '9' THEN price ELSE 0 END), 2) AS 't9',
ROUND(SUM(CASE WHEN typecode != '' THEN price END), 2) AS 'sumprice'
FROM Bill
GROUP BY Phone