Oracle
select employee_id, last_name
sal x 12 annual salary
from employees;
Software/Hardware used:
sqlplus
Software/Hardware used:
sqlplus
ASKED:
August 29, 2012 4:16 PM
UPDATED:
August 29, 2012 5:13 PM
and your question is??????
select employee_id, last_name sal x 12 “annual salary” from employees
or
select employee_id, last_name sal x 12 as “annual salary” from employees
Needs ” around column name if it’s more than one word. In the future please ask a question.
select employee_id, last_name sal * 12 “annual salary” from employees
Multiply with an X .. no multiply with an *.
Wow there is a comma missing between last_name and Sal.
That’s three errors. Don’t expect this much help on future homework.
select employee_id, last_name, sal * 12 “annual salary” from employees
SELECT EMPLOYEE_ID ,LAST_NAME,SAL*12 AS “ANNUAL_SALARY”
FROM EMPLOYEES;