sql server分页查询

@Select(“<script>” +
　　　　”select top ${pageSize} * from (” +
　　　　”select row_number() over(order by K6001,k0101) as rownumber,name ” +
　　　　”from ${dataBaseName}.dbo.k060 where 1 = 1 ” +
　　　　”) temp_row where rownumber > ((#{currentPage}-1) * #{pageSize}) ” +
　　　　”</script>”)
List<BridgeBasicData> getBridgeBasicData(@Param(“currentPage”) Integer currentPage,@Param(“pageSize”) Integer pageSize);