String sql = "select * from(SELECT [id] ,[name],[price] ,[addDate],[state],[picture],ROW_NUMBER() over(order by id desc) row FROM [Product]) t where t.row>=? and t.row<=?";
Sqlserver 分页
原文:https://www.cnblogs.com/gzhbk/p/11212812.html