Posted by markc600 on 03/23/06 12:27

UPDATE employment
SET sal=(
SELECT AVG(employee.sal)*2
FROM employee
WHERE employment.managerid=employee.managerid)

• Next in forum: Re: How do I change the default collation string of an installation
• Prev in forum: Re: How do I change the default collation string of an installation
• Thread view: Re: Update the salary of each manager to be double the average salary of the employees he/she manages

[Reply to this message]