Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: ROWID in MS SQL

    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...

Viewing post 1 (of 1 total)