Hide ROW_NUMBER() in subquery
<p>I have a query like</p>

<pre><code>Select *
From y
WHERE y.z = (
SELECT a, (adding rownumber here)
FROM b
)
</code></pre>

<p>I want to add a clause where it only selects every second row. To do this I need to add row_number() to the subquery, and have a clause where rownumber % 2 = 0.</p>

<p>My question is, am I able to add rownumber to the select of the subquery and somehow hide it so it doesn't affect the query</p>