I'm trying to create a SQL query that outputs duplicate values in a sequence. There are other similar posts, but none that seem to work for my needs.
Here is what I've tried so far.
select created, count(*)
from users
group by created
... with the following results
2010-10-12 12:06:44 1
2014-02-24 20:36:50 1
2014-02-25 11:14:18 1
2014-02-25 14:13:44 1
2014-02-25 21:08:53 1
2014-02-25 22:22:17 1
2014-02-26 01:59:07 1
2014-02-26 12:08:59 1
But, I'm actually trying to get it into this format.
2010-10-12 1
2014-02-24 1
2014-02-25 4
2014-02-26 2
I need the count of each date, but haven't been able to get the right query. Thank you for your help.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments