• It's important to note that none of these solutions will guarantee to delete the same rows as are being returned by the select statement (nor indeed is the select statement guaranteed to return the same rows each time).

    Because your row number order is entirely arbitrary, a different plan could well result in different results.

    My question is, why would you want to arbitrarily delete rows with no apparent logic?