another version is:

DECLARE @intPageNumber INT = 1, @intPageSize INT = 20;

SELECT A.AdID, A.AdTitle, A.AdFor, A.AdCondition, A.AdExpPrice, A.CreatedDate, A.ModifiedDate, A.AdUID

FROM

(

SELECT TOP(@intPageNumber * @intPageSize) ROW_NUMBER() OVER (ORDER BY vaa.CreatedDate) AS RowNum,

vaa.AdID, vaa.AdTitle, vaa.CityID, vaa.AdFor, vaa.AdCondition,

vaa.AdExpPrice, vaa.CreatedDate, vaa.ModifiedDate, vaa.AdUID

FROM Catalogue.vwAvailableActiveAds vaa

WHERE vaa.CategoryID = 1 AND vaa.CountryCode = 'GB' AND vaa.CreatedDate > DATEADD(dd, -90, GETUTCDATE())

AND vaa.StateID = 1737 AND vaa.CityID = 86

) A

WHERE A.RowNum > (@intPageSize * (@intPageNumber - 1));

Which one is efficient?