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
答案解析:有

微信扫一扫手机做题