问题
单项选择题
下列哪个语句查出雇员表(employees)里的雇员名字(ename)是‘SMITH’的信息,并且给雇员名字(ename)列定义一个别名Name()。
A.select employeesno,ename Name,job from employees where ename=‘SMITH’
B.select employeesno,ename ‘Name’,job from employees where ename=SMITH
C.select employeesno,ename “Name”,job from employees where ename=‘SMITH’
D.select employeesno,ename ‘Name’,job frome mployees wheree name=‘SMITH’
答案
参考答案:A