Здравейте колеги,
Моля къжете ми къде греша на тази задача. Кодът ми е следния:
UPDATE Employees
SET Salary=Salary*1.12
WHERE JobTitle IN(
'Engineering Manager',
'Tool Designer',
'Marketing Assistant',
'Marketing Manager',
'Marketing Specialist',
'Information Services Manager')
SELECT Salary FROM Employees
Благодаря предварително!
В департаментите 'Engineering', 'Tool Design', 'Marketing', 'Information Services' има 13 различни професии JobTitle. Ти си изредил 6.
Application Specialist: Information Services
Database Administrator: Information Services
Design Engineer: Engineering
Engineering Manager: Engineering
Information Services Manager: Information Services
Marketing Assistant: Marketing
Marketing Specialist: Marketing
Network Administrator: Information Services
Network Manager: Information Services
Senior Design Engineer: Engineering
Senior Tool Designer: Tool Design
Tool Designer: Tool Design
Vice President of Engineering: Engineering
Не знам защо си решил да ги проверяваш по JobTitle. Не е ли по-добра идея по DepartmentID?
UPDATE [Employees]
SET [Salary] *= 1.12
WHERE [DepartmentId] IN
(SELECT [DepartmentId]
FROM [Departments]
WHERE [Name] IN
('Engineering', 'Tool Design', 'Marketing', 'Information Services'))
SELECT [Salary]
FROM [Employees]
Естествено! Не погледнах изобщо Departments... Благодаря!