DataBase
SQL
- Group by
SELECT top 2 convert(varchar(4),YEAR([time])) + '-' + convert(varchar(2),MONTH([time])) + '-' + convert(varchar(2),Day([time])) AS mytime, count = count(*) FROM AD_DisplayRecord GROUP BY convert(varchar(4),YEAR([time])) + '-' + convert(varchar(2),MONTH([time])) + '-' + convert(varchar(2),Day([time])) order by mytime desc