6) Display the employee name and annual salary for all employees. SQL>select ename, 12*(sal+nvl(comm,0)) as "annual Sal" from emp.
確定! 回上一頁