ROWID in MS SQL

Other SQL Server Topics
1

How to rewrite a query in MS SQL, please:

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 > ( SELECT max(id)
FROM details d
WHERE d.id = c.id
AND d.cd = '2025')
AND c.cd IN ( '2017','2012','2021'))
WHERE rn = 1 )

2

hi

hope this helps

WHERE a.ROWID IN (  
    SELECT TOP 1 ROWID  
    FROM details c  
    WHERE a.id = c.id  
    AND c.id > (  
        SELECT MAX(id)  
        FROM details d  
        WHERE d.id = c.id  
        AND d.cd = '2025'  
    )  
    AND c.cd IN ('2017', '2012', '2021')  
    ORDER BY c.id  
)