> > >

Hadoop MCQs

What is the correct SQL syntax for selecting all the columns 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 customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen'

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

Answer

Correct Answer:

Explanation:

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

Hadoop Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it