Which of the following MySQL query will display all the NAME from the table…
PYQ EMRS TGT/PGT (ESSE) 2023Modified — slightly modified from the official paper; see the solution
Which of the following MySQL query will display all the NAME from the table STUDENT, which are having exactly five characters and starting with the alphabet ‘A’ ?
- A.
SELECT NAME FROM STUDENT WHERE NAME LIKE 'A____';
- B.
SELECT NAME FROM STUDENT WHERE NAME = 'A____';
- C.
SELECT NAME FROM STUDENT WHERE NAME = 'A%%%%';
- D.
SELECT NAME FROM STUDENT WHERE NAME LIKE 'A%%%%';
Attempted by 500 students.
Sign up free to check your answer
Sign up freeLoading lesson…

