I have a very large table that is ordered. since I know the ordering, I want to create an UPDATE statement to only update the nth records. Something like:
UPDATE table set state = <value> where MOD(ROW_NUMBER(),24) = 0;
Is there some syntax that allows this? Note that this is not a SELECT but an UPDATE.