3. Using Functions : Step 5

Demo

Name the computed field

Computed fields can be named

SQL

SELECT ename, sal*12 AS "Annual salary" FROM emp

Output

ename Annual salary
SMITH 9600.00
ALLEN 19200.00
WARD 15000.00
JONES 35700.00
MARTIN 15000.00
BLAKE 34200.00
CLARK 29400.00
SCOTT 36000.00
KING 60000.00
TURNER 18000.00
ADAMS 13200.00
JAMES 11400.00
FORD 36000.00
MILLER 15600.00

Progress

Proceed to Next step