查询指定范围内数据记录(适用于sqlserver2005以上)

 WITH OrderedOrders AS

 (SELECT ROW_NUMBER()over(order by g_Id asc) as RowNumber,g_Id FROM guanxi) 

 SELECT * 

 FROM OrderedOrders 

 WHERE RowNumber BETWEEN 50 AND 60;