SQL query to group by day

by

if you’re using SQL Server,

dateadd(DAY,0, datediff(day,0, created)) will return the day created

for 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))

More Related Contents:

  1. SQL GROUP BY CASE statement with aggregate function
  2. Add a column with a default value to an existing table in SQL Server
  3. Simulating group_concat MySQL function in Microsoft SQL Server 2005?
  4. How can I do an UPDATE statement with JOIN in SQL Server?
  5. The multi-part identifier could not be bound
  6. How to return multiple values in one column (T-SQL)?
  7. Fastest way to update 120 Million records
  8. Is it possible to select sql server data using column ordinal position
  9. How to find current transaction level?
  10. How to insert multiple records and get the identity value?
  11. How to Replace Multiple Characters in SQL?
  12. How can a LEFT OUTER JOIN return more records than exist in the left table?
  13. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  14. Dynamic SQL to generate column names?
  15. SQL comma-separated row with Group By clause
  16. How to copy a huge table data into another table in SQL Server
  17. Column name or number of supplied values does not match table definition
  18. SQL Server PIVOT perhaps?
  19. How to find consecutive rows based on the value of a column?
  20. Should I use SQL_Variant data type?
  21. SQL server select distinct rows using most recent value only
  22. Script to save varbinary data to disk
  23. Measuring Query Performance : “Execution Plan Query Cost” vs “Time Taken”
  24. How to escape square brackets inside square brackets for field name
  25. How to return a incremental group number per group in SQL
  26. Eliminate and reduce overlapping date ranges
  27. SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
  28. SQL Sort Order with Null values last
  29. Insert all values of a table into another table in SQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment