多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You need to display the last names of those employees who have the letter “A” as the second character in their names.Which SQL statement displays the required results?()

  • A、SELECT last_name   FROM EMP   WHERE last_name LIKE ‘_A%’;
  • B、SELECT last_name   FROM EMP   WHERE last name =’*A%’
  • C、SELECT last_name   FROM EMP   WHERE last name =’_A%’;
  • D、SELECT last_name   FROM EMP   WHERE last name LIKE ‘*A%’
正确答案:A
答案解析:
进入题库查看解析

微信扫一扫手机做题