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"?
- A.
SELECT * FROM EMPLOYEE WHERE NAME LIKE "_A%"; / SELECT FROM EMPLOYEE WHERE NAME LIKE "_A%";
- B.
SELECT FROM EMPLOYEE WHERE NAME LIKE "%A_"; / SELECT FROM EMPLOYEE WHERE NAME LIKE "%A_";
- C.
SELECT * FROM EMPLOYEE WHERE NAME LIKE '%A%';
- 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 freeLoading lesson…

