MCQs > IT & Programming > MySQL > How do you select all the records from a table named 'Persons' where the 'FirstName' is 'Peter' and the 'LastName' is 'Jackson'?

MySQL MCQs

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

Answer

Correct Answer: SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it

search

MySQL Skill Assessment

Overall Skill Level-Poor

Your Skill Level: Poor

Retake Quizzes to improve it