SELECT C_BH,C_BT,C_BirthCorpID
FROM
(
SELECT rid=ROW_NUMBER()
OVER(PARTITION BY C_BirthCorpID
ORDER BY D_FBSJ DESC),
*
FROM T_GY_WZ
) AS T
WHERE rid<=3
FROM
(
SELECT rid=ROW_NUMBER()
OVER(PARTITION BY C_BirthCorpID
ORDER BY D_FBSJ DESC),
*
FROM T_GY_WZ
) AS T
WHERE rid<=3