This week's book giveaway is in the Agile and Other Processes forum. We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line! See this thread for details.
This query will return as many rows as there are VALUEs and COUNTs for a given date, but I am not interested in all VALUEs, only in the one with the max(COUNT) on a given date. Can you please help me build the sql statement I need ?
I tried with the sql below but I basically got the same results.