sql=WITH OrderedList AS( SELECT *, ROW_NUMBER() OVER ( Order by Lastupdated Desc ) AS 'RowNumber' from AnimalSummaryViewB WHERE speciesID = 9 and country_id = 1228 ) SELECT * FROM OrderedList WHERE RowNumber BETWEEN 1 AND 10 Order by Lastupdated Desc ;