KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel