34,576
社区成员
发帖
与我相关
我的任务
分享
有表如下:
a date
-------------------
1 2010-7-1 16:10
2 2010-7-1 1:10
3 2010-7-2 12:10
4 2010-7-2 10:10
5 2010-7-3 20:10
6 2010-7-3 22:10
SELECT SUM(A) AS A,CONVERT(VARCHAR(10),DATE,120)
FROM TBA
GROUP BY CONVERT(VARCHAR(10),DATE,120)
SELECT SUM(A) AS A,CONVERT(VARCHAR(10),DATE,120)
FROM TBA
GROUP BY CONVERT(VARCHAR(10),DATE,120)
SELECT SUM(A) AS A,CONVERT(VARCHAR(10),DATE,120) AS DATE
FROM TB
GROUP BY CONVERT(VARCHAR(10),DATE,120)