Sql查询分组按天 [英] Sql query to Group by day
本文介绍了Sql查询分组按天的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
销售额(saleID INT,金额INT,已创建)我想列出所有销售额并按天计算总额。 DATETIME)
更新
我正在使用SQL Server 2005
解决方案
如果您使用的是SQL Server,则可以使用
dateadd(DAY,0,datediff(day,0,created))
将返回创建的日期
在'2009-11-02 06:12:55.000',
dateadd(DAY,0,datediff(day,0,created))创建的销售
return' 2009-11-02 00:00:00.000'
选取金额总额,dateadd(DAY,0,datediff (日,0,已创建))创建
pre>
从销售
group by dateadd(DAY,0,datediff(day,0,created))
I want to list all sales, and group the sum by day.
Sales (saleID INT, amount INT, created DATETIME)
Update I am using SQL Server 2005
解决方案if you're using SQL Server,
dateadd(DAY,0, datediff(day,0, created))
will return the day createdfor example, if the sale created on '2009-11-02 06:12:55.000',
dateadd(DAY,0, datediff(day,0, created))
return '2009-11-02 00:00:00.000'select sum(amount) as total, dateadd(DAY,0, datediff(day,0, created)) as created from sales group by dateadd(DAY,0, datediff(day,0, created))
这篇关于Sql查询分组按天的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文