Qtr No. 213, New Town Yehlanka Indore 454775
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;
To get all Infosys Certified MySQL Associate Exam questions Join Group https://bit.ly/infy_premium_group
We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.
Qtr No. 213, New Town Yehlanka Indore 454775
admin@prepflix.in
