试题详情
单项选择题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
  • 关注下方微信公众号,在线模考后查看

热门试题