How to multiply two columns & sum it?

[muralirajan]

How to find the sum of salary departmentwise after the increment from the following table?

EmpId ** DeptId ** Salary ** %OfIncrement

001 ***** 100 ***** 20000 ***** 30
002 ***** 100 ***** 15000 ***** 25
003 ***** 200 ***** 10000 ***** 15
004 ***** 200 ***** 17500 ***** 10


I want the SQL statement which gives the following

DeptId ***** SumOfSalary

SumOfSalary is the sum of (Salary * %OfIncrement / 100) departmentwise


muralirajan

[Lothar Haensler]

select sum (salary *...)/100 group by deptid

What do you think this forum is for? If you need a contract programmer, I'll be happy to send you my rates :-)