CREATE TABLE dbo.MaxTest (Name varchar(50), PayRate decimal(14,4)) insert into dbo.MaxTest values ('Kevin', 50), ('Katy', 60)Here are 2 code samples. What will happen in each of the two examples? (will I get an error, will I get a result, etc.)
DECLARE @MaxRate decimal(14,4) SET @MaxRate = (SELECT MAX(PayRate) from dbo.MaxTest GROUP BY Name) SELECT @MaxRatesample 2:
DECLARE @MaxRate decimal(14,4) SELECT @MaxRate = MAX(PayRate) FROM dbo.MaxTest GROUP BY Name SELECT @MaxRate