Multiply in Query

[barbara1712]

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,

[bubbisthedog]

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

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.