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?
SELECT last_name FROM EMP WHERE last_name LIKE ‘_A%’;
SELECT last_name FROM EMP WHERE last name =’*A%’
SELECT last_name FROM EMP WHERE last name =’_A%’;
SELECT last_name FROM EMP WHERE last name LIKE ‘*A%’