select year(dt1) as dm,DATEDIFF(yy,dt1,getdate())+1 as xmname,COUNT(dt1) AS xmnum
from PersonResume
group by year(dt1),DATEDIFF(yy,dt1,getdate())+1
ORDER BY COUNT(dt1) desc
DECLARE @dckhjf TABLE
(
dm nvarchar(200),
xmname nvarchar(200)
)
INSERT into @dckhjf
select year(dt1) as dm,DATEDIFF(yy,dt1,getdate())+1 as xmname from PersonResume
select dm, xmname,count(xmname) as xmcount from @dckhjf group by xmname,dm order by xmcount desc