在Microsoft SQL Server 2012上选择内部联接中的第n行

My gifts table has multiple rows that match the criteria in the inner join statement below. I want to select a specific row (3rd, 5th or 32nd row as examples). I have tried using Row_Number(), but it is a windowed function and needs to be within the select part (as far as I know), but that then throws errors, because the overall statement has to return only one value. My gifts table has multiple rows that match the