Which of the following MySQL query will display all the NAME from the table…
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 STUDENTWHERE NAME LIKE 'A____'; - B.
SELECT NAME FROM STUDENTWHERE NAME = 'A____'; - C.
SELECT NAME FROM STUDENTWHERE NAME = 'A%%%%%'; - D.
SELECT NAME FROM STUDENTWHERE NAME LIKE 'A%%%%%';
Attempted by 2726 students.
Sign up free to check your answer
Sign up freeLoading lesson…

