Multiply in Query

Hello All,

Is there is a built-in function like sum(),min(),Max,etc which calculate the product of the field.
For ex: I want the product of salary for department = 1

Thanks in advance,

Is it a product or a sum that you're wanting?

Code:

---

select sum(salary)
from ...
where department = 1

---

The above query (after you complete the joins and what-not, if necessary) will return the total salary paid for department 1.