试题详情
单项选择题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%’

  • 关注下方微信公众号，在线模考后查看

热门试题