Which of the following will display information about all the employees from…

2023

Answer: A. SELECT * FROM EMPLOYEE WHERE NAME LIKE "_A%"; — To find employees whose second letter is 'A', use the SQL LIKE pattern: _ (underscore) → matches exactly one character

1. A.

   SELECT * FROM EMPLOYEE WHERE NAME LIKE "_A%";

2. B.

   SELECТ * FROM EMPLOYEE
   WHERE NAME LIKE "% A_";

3. C.

   SELECT * FROM EMPLOYEE
   WHERE NAME LIKE "_ _A%";

4. D.

   SELECT * FROM EMPLOYEE
   WHERE NAME = _A%";

Attempted by 2115 students.