Got a single SQL table which I am wanting to query and update top 5 rows when doing so. The following does not work (hence the question) but might explain what it is I am trying:

```
UPDATE 
    TempStaging
SET 
    pending = 'running'
FROM 
    (SELECT TOP 5 scan FROM TempStaging
         WHERE pending = 'outstanding')

```