Which of the following will display information about all the employees from…
2023
Which of the following will display information about all the employees from employee table, Whose names contains second letter as "A" ?
- A.
SELECT * FROM EMPLOYEE WHERE NAME LIKE "_A%";
- B.
SELECТ * FROM EMPLOYEE
WHERE NAME LIKE "% A_"; - C.
SELECT * FROM EMPLOYEE
WHERE NAME LIKE "_ _A%"; - D.
SELECT * FROM EMPLOYEE
WHERE NAME = _A%";
Attempted by 1756 students.
Show answer & explanation
Correct answer: A
To find employees whose second letter is 'A', use the SQL LIKE pattern: _ (underscore) → matches exactly one character