How to rewrite a query in MS SQL:

WHERE a.ROWID IN (SELECT rid

FROM ( SELECT ROWID rid,

row_number() OVER (PARTITION BY c.id ORDER BY c.id) rn

FROM details c

WHERE a.id = c.id

AND c.id...