Hi Everyone,
As we know sum is a predefined oracle function. But what these oracle guys have used for the input parameters. How they have done this?
I mean we can write this sum fuction like so many ways like as mentioned below. Please give me some ideas how to do that.
SELECT SUM(salary) as "Total Salary" FROM employees;
SELECT SUM(DISTINCT salary) as "Total Salary" FROM employees;
SELECT SUM(income - expenses) as "Net Income" FROM gl_transactions;
SELECT SUM(sales * 0.10) as "Commission" FROM order_details;
Regards,
BS2012