SOLVED: Which of the below query suits for below scenario? Show all records from the Can ...

Which of the below query suits for below scenario? Show all records from the Candidate table in the increasing order of phone number column value, whose name does not containing "Jack" and whose phone number is '456783'.

SELECT * FROM Candidate WHERE name <> "%Jack%" AND phone_number = '456783' order by phone_number;

SELECT * FROM Candidate WHERE name not = "Jack" AND phone_number == '456783' order phone_number;

SELECT * FROM Candidate WHERE name != "%Jack%" AND phone_number == '456783' order by phone_number;

SELECT DISTINCT * FROM Candidate WHERE name == "%Jack%" AND phone_number = '456783' order by phone_number;

Verified Answer

Correct Option - a

To get all Infosys Certified MySQL Associate Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee