单选题

Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12? ()

ASELECT ename, salary*12 'Annual Salary' FROM employees;

BSELECT ename, salary*12 "Annual Salary" FROM employees;

CSELECT ename, salary*12 AS Annual Salary FROM employees;

DSELECT ename, salary*12 AS INITCAP("ANNUAL SALARY") FROM employees

正确答案

来源:www.examk.com

答案解析