SQL Server Server query - Count distinct DateTime field

Posted by strakastroukas on Stack Overflow See other posts from Stack Overflow or by strakastroukas
Published on 2009-05-20T13:16:18Z Indexed on 2010/04/06 20:03 UTC
Read the original article Hit count: 259

Filed under:
|
|

Supposing we have the following records in an SQL Server table.

Date
19/5/2009 12:00:00 pm
19/5/2009 12:15:22 pm
20/5/2009 11:38:00 am

What is the SQL syntax for getting something like this one?

Date Count
19/5/2009 2
20/5/2009 1

© Stack Overflow or respective owner

Related posts about sql

Related posts about distinct