You need to display the last nam_睦霖题库

单项选择题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
答案解析：
关注下方微信公众号，在线模考后查看

热门试题