SELECT distinct(CONVERT(varchar(7), AddTime, 111)) AS AddTime, count(userid) as allcount, autoid= ROW_NUMBER() over(ORDER BY (CONVERT(varchar(7), AddTime, 111)) DESC) from users group by (CONVERT(varchar(7), AddTime, 111)) order by (CONVERT(varchar(7), AddTime, 111)) desc