Select * from (Select distinct Rank = ROW_NUMBER() OVER (order by nott.PubDate desc), nott.OrderID, nott.Alias, nott.OrderTop, nott.Ref, nott.PubDate, nott.EndDate, nott.OrderStatusID, nott.CustomerID, nott.Login, nott.RegistryDate, nott.Picture, nott.City, nott.GetMarks, nott.Experience, nott.GetInvitations, nott.GetRecommendations, nott.CustomerLevel, nott.TotalRating, nott.CustomerOrders, nott.CustomerLevelID, nott.CountMarks, nott.CountRecommendations, nott.CountPositive, nott.CountNegative, nott.TarifID, nott.Spetsnaz, nott.HrClub, nott.HRTop30, nott.Top100, nott.Company, nott.CountViews, nott.CountInvitation, nott.Checked, nott.PRO from vNotTenders nott where nott.NewOrderTypeID=2 and (nott.OrderStatusID=1 or nott.OrderStatusID=2)) as Orders WHERE Rank BETWEEN 36121 AND 36150 order by Orders.PubDate desc, Rank