select zrzh,bdcdyh from
(select *, ROW_NUMBER() over(partition by zrzh order by FWBH desc) as rownum from TCBDCDJ.dbo.h A)t
where rownum<=2 ORDER BY zrzh
(select *, ROW_NUMBER() over(partition by zrzh order by FWBH desc) as rownum from TCBDCDJ.dbo.h A)t
where rownum<=2 ORDER BY zrzh