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

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%'
查看答案

微信扫一扫手机做题