( B )SQL語句將為計算列SAL*12生成別名Annual Salary
A. SELECT ename,sal*12 ‘Annual Salary’ FROM emp;?
B. SELECT ename,sal*12 “Annual Salary” FROM emp;
C. SELECT ename,sal*12 AS Annual Salary FROM emp;
D. SELECT ename,sal*12 AS INITCAP(“Annual Salary”) FROM emp;
如題正確答案是b選項
為什么不選c?
因為 “Annual Salary” 中間有空格
標簽: