SQL语句如何写

[暗尘掩月]

表结构如下

addtime result
2012-1-1 负
2012-1-1 胜
2012-1-1 负
2012-2-1 负
2012-2-2 胜
2012-2-2 负

查询结果如下
日期 结果 统计
2012-1-1 负 2
2012-1-1 胜 1
2012-2-1 负 1
2012-2-2 胜 1
2012-2-2 负 1

[ParanoidKing]

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]

[zjwz001]

[Quote=引用 1 楼 的回复:]

SQL code

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]
[/Quote]

+1

[IssacChow]

[Quote=引用 1 楼 的回复:]

SQL code

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]
[/Quote]就是一个分组统计嘛!

[_萧萧]

 SELECT [addtime] AS [日期], [result] AS [结果],        
                      CASE WHEN [result]='胜' THEN '1' WHEN 
                      [result]='负' THEN '2' END AS 统计 FROM [XXX] GROUP BY [addtime],[result]  

[yuzan0123]

[Quote=引用 4 楼 的回复:]
SQL code

SELECT [addtime] AS [日期], [result] AS [结果],
CASE WHEN [result]='胜' THEN '1' WHEN
[result]='负' THEN '2' END AS 统计 FROM [XXX] GROUP BY……
[/Quote]

+1 分组求和

[tan598121925]

++[Quote=引用 4 楼 的回复:]

SQL code

SELECT [addtime] AS [日期], [result] AS [结果],
CASE WHEN [result]='胜' THEN '1' WHEN
[result]='负' THEN '2' END AS 统计 FROM [XXX] GROUP BY [……
[/Quote]

[ONE-PIECE]

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]
+++++++++++++++++++++++++++++++++++++++++=

[zhangdaowu5]

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]
+++

或者用 for xml 函数进行拼接。

[beican_shijie]

[Quote=引用 1 楼 的回复:]

SQL code

SELECT [addtime] AS [日期], [result] AS [结果], COUNT(1) AS [统计] FROM [XXX] GROUP BY [addtime],[result]
[/Quote]

+++

[kaikai_kk]

这问题