Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?（）
- A、SELECT ename, salary*12 'Annual Salary' FROM employees;
- B、SELECT ename, salary*12 "Annual Salary" FROM employees;
- C、SELECT ename, salary*12 AS Annual Salary FROM employees;
- D、SELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees
正确答案:B
答案解析:有
微信扫一扫手机做题