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 WH

题目

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
相关内容