【MSSQL】名稱相同址更新最新一筆資料

UPDATE _test SET [value]='100' WHERE id  = (SELECT TOP 1 id FROM _test WHERE [name]='aa' ORDER BY id DESC) AND [name]='aa'