T-SQL UPDATE Statement with TOP clause - INNER JOIN - SQLUSA

-- T-SQL UPDATE statement with TOP filtering -- SQL INNER JOIN with SELECT subquery (subselect) UPDATE a SET BaseRate = 1.1 * BaseRate FROM HumanResources. Employee a INNER JOIN (SELECT TOP (10 ) PERCENT WITH . ORDER BY ) ...

www.sqlusa.com