I need a query that selects the amount of records for each day in a table.

I need a query that selects the amount of records for each day in a table.
Eg the result would be:

date 1 14
date 2 3

etc

Any ideas?

This topic has been closed for replies.

Correct answer nikos101

sorted:

SELECT count([commentID]),convert(varchar, dateAdded, 112)

FROM COMMENTSgroup by convert(varchar, dateAdded, 112)

nikos101AuthorCorrect answer

Inspiring

sorted:

SELECT count([commentID]),convert(varchar, dateAdded, 112)

FROM COMMENTSgroup by convert(varchar, dateAdded, 112)

Sign up