Update TOP 100 records

[M8KWR]

is there a way to just update the top 100 records of a table with an update query.

The only way i can think of doing it is by creating a query that select the top 100 then cross reference this back against itself, and then update

But can it be done in one query...

 

[cheerio]

UPDATE ...
WHERE keyID in 
(SELECT TOP 100 keyID FROM ...
ORDER BY ...)