Alex Rivera | Logout

How to count number of records per day?

Asked 2012-02-10T15:09:15.973
32

I have a table in a with the following structure:

CustID --- DateAdded ---

 396       2012-02-09 
 396       2012-02-09 
 396       2012-02-08 
 396       2012-02-07 
 396       2012-02-07
 396       2012-02-07 
 396       2012-02-06
 396       2012-02-06

I would like to know how I can count the number of records per day, for the last 7 days in SQL and then return this as an integer.

At present I have the following SQL query written:

SELECT * 
  FROM Responses
 WHERE DateAdded >= dateadd(day, datediff(day, 0, GetDate()) - 7, 0)

RETURN

However this only returns all entries for the past 7 days. How can I count the records per day for the last 7 days?

sql sql-server count
Edit
Report

2 Answers

11
select DateAdded, count(CustID)
from tbl
group by DateAdded

about 7-days interval it's DB-depending question

answered 2012-02-10T15:11:09.153
0
select DateAdded, count(DateAdded) as num_records
from your_table
WHERE DateAdded >=dateadd(day,datediff(day,0,GetDate())- 7,0)
group by DateAdded
order by DateAdded
answered 2012-02-10T15:12:33.630

Your Answer