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

PYQ KVS TGT/PGT 2023

Which of the following will display information about all the employees from employee table, whose names contains second letter as "A"?

  1. A.

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

  2. B.

    SELECT FROM EMPLOYEE WHERE NAME LIKE "%A_"; / SELECT FROM EMPLOYEE WHERE NAME LIKE "%A_";

  3. C.

    SELECT * FROM EMPLOYEE WHERE NAME LIKE '%A%';

  4. D.

    SELECT FROM EMPLOYEE WHERE NAME ="_A%" / SELECT FROM EMPLOYEE WHERE NAME ="_A%"

Attempted by 2647 students.

Sign up free to check your answer

Sign up free

Explore the full course: Kvs Nvs Tier 2 Computer Science

Loading lesson…