> > >

MySQL MCQs

What is the correct SQL syntax for selecting all the columns from the table Persons where the
LastName is alphabetically between (and including) "Hansen" and "Pettersen"?

SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen'

SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons

SELECT * FROM persons WHERE LastName > 'Hansen' AND LastName > 'Pettersen'

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

Answer

Correct Answer: SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

Explanation:

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

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it