Group by troubles
View Single Post
03-21-2013, 06:04 AM
Supreme Master coder!
Join Date: Feb 2009
Thanked 4,306 Times in 4,273 Posts
Trivial in MySQL (and SQL Server, not so easy in some other DBs).
SELECT myDate, COUNT(
myClient ) FROM tablename GROUP BY myDate ORDER BY myDate
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
View Public Profile
Find More Posts by Old Pedant