试题详情
单项选择题下列哪个语句查出雇员表(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
  • 关注下方微信公众号,在线模考后查看

热门试题