How to count number of records per day

Question

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  gt   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

User · Answer

You could also try this  SELECT DISTINCT  DATE dateadded   AS unique date  COUNT    AS amount FROM table GROUP BY unique date ORDER BY unique date ASC

User · Answer

If your timestamp includes time  not only date  use   SELECT DATE FORMAT  timestamp     Y- m- d   AS date  COUNT id  AS count FROM table GROUP BY DATE FORMAT  timestamp     Y- m- d

User · Answer

SELECT DateAdded  COUNT 1  AS NUMBERADDBYDAY FROM Responses WHERE DateAdded  gt   dateadd day datediff day 0 GetDate   - 7 0  GROUP BY DateAdded

User · Answer

select DateAdded  count CustID  from Responses WHERE DateAdded  gt  dateadd day datediff day 0 GetDate   - 7 0  GROUP BY DateAdded

User · Answer

select DateAdded  count CustID  from tbl group by DateAdded   about 7-days interval it s DB-depending question

User · Answer

SELECT count     dateadded FROM Responses WHERE DateAdded  gt  dateadd day datediff day 0 GetDate   - 7 0  group by dateadded  RETURN   This will give you a count of records for each dateadded value   Don t make the mistake of adding more columns to the select  expecting to get just one count per day   The group by clause will give you a row for every unique instance of the columns listed

User · Answer

This one is like the answer above which uses the MySql DATE FORMAT   function  I also selected just one specific week in Jan    SELECT      DatePart day  DateAdded  AS date       COUNT entryhash  AS count  FROM Responses      where DateAdded  gt   2020-01-25  and DateAdded  lt   2020-02-01   GROUP BY      DatePart day  DateAdded

User · Answer

select DateAdded  count DateAdded  as num records from your table WHERE DateAdded  gt  dateadd day datediff day 0 GetDate   - 7 0  group by DateAdded order by DateAdded

[sql] How to count number of records per day?

Examples related to sql

Examples related to sql-server

Examples related to count