Which of the following is not available in MySQL?

Which of the following is NOT supported in MySQL?
(A). FETCH
(B). LIKE
(C). REVOKE
(D). JOIN
MCQ Answer:(A). FETCH

Example of LIKE Query in MySQL

It will show all teacher’s names starting with t

SELECT * FROM Teachers
WHERE TeacherName LIKE 't%';

1 2	SELECT * FROM Teachers WHERE TeacherName LIKE 't%';

To revoke all privileges from a user, we can write the following REVOKE ALL query:

REVOKE 
    ALL [PRIVILEGES], 
    GRANT OPTION 
FROM user1 [, user2];

REVOKE

ALL [PRIVILEGES],

GRANT OPTION

FROM user1 [, user2];

select * from t4tutorials_finance inner join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

select * from t4tutorials_finance left join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id

select * from t4tutorials_finance right join user_details on user_details.userid=T4Tutorials_finance.t4tutorials_id