I need to update a specific row within a table something like this:
UPDATE mytable SET myfield = 10 WHERE (ROWNUMBER = 4)
but I can't find a good way to identify the row. I've looked at ROW_NUMBER(), IDENTITY(), and RANK(), but none of them seem to fit. Could someone explain how to do this?