SQL中分页与distinct冲突解决方案

SELECT list.* FROM(SELECT ROW_NUMBER() OVER(ORDER BY salesStatus.LastTime DESC,school.SchoolID DESC) AS rownumber, school.SchoolID,school.SchoolName,school.ProvinceID,school.CityID,school.DistrictID,salesStatus.IsHave,salesStatus.IsLocked,salesStatus.IsShortProtect,SELECT list.* FROM(SELECT ROW_NUMBER() OVER(ORD