If the CREATE TABLE statement defined the format for the Salary column as ‘ZZ9999.99’, the result of the statement:
SELECT SUM(Salary) FROM Employee;
is:
SUM(Salary) ----------- 851100.00
If the CREATE TABLE statement defined the format for the Salary column as ‘ZZ9999.99’, the result of the statement:
SELECT SUM(Salary) FROM Employee;
is:
SUM(Salary) ----------- 851100.00