I am having problems implementing code to perform a couple calculations and setting column aliases.
The management wants to increase salary of all employees by 10%. Write a query to display empid, current salary, increased salary and incremented amount.
Salary AS 'Current Salary',
Salary*1.10 AS 'New Salary',
Salary*1.10-Salary AS 'Incremented Amount'
enclose the alias with double quote.
SELECT EmpId, Salary AS "Current Salary", Salary*1.10 AS "New Salary", Salary*1.10-Salary AS "Incremented Amount" FROM EmpDetails