select top 5000 * from
(
select top 10000 *,row_number() over(order by MDMZGZD_NM,MDMZGZD_ZGBH) as rowId from
(
select * from MDMZGZDMapping where F_YWXTBH IN (‘XZSP‘) AND F_MDMNM in(select MDMZGZD_NM from MDMZGZD
) C order by rowId
) D order by rowId desc
原文：http://www.cnblogs.com/zhchsh/p/5461480.html