试题详情
- 单项选择题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
关注下方微信公众号,在线模考后查看
热门试题