select t1.* from
(select t.*,row_number() over (order by id) rn from
(SELECT TOP 1000 [Name]
,[CtfId]
,[Gender]
,[Birthday]
,[Address]
,[Mobile]
,[Tel]
,[Fax]
,[EMail]
,[Family]
,[Version]
FROM [1234567].[dbo].[cdsgus]) t) t1
where rn between 500 and 700
其实后边有个id里，你可以根据那个来查
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024