DRAG DROP
You have a table named HR.Employees as shown in the exhibit. (Click the exhibit button.)
You need to write a query that will change the value of the job title column to Customer Representative for any
employee who lives in Seattle and has a job title of Sales Representative. If the employee does not have a
manager defined, you must not change the title.
Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate
Transact-SQL segments from the list of Transact-SQL segments to the answer area and arrange them in the
correct order.
Select and Place:
Explanation:
https://msdn.microsoft.com/en-us/library/ms177523.aspx
right