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 36061 AND 36090 order by Orders.PubDate desc, Rank