Multiple choice technology databases

  1. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

  1. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

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

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

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The BETWEEN operator in SQL is inclusive - it includes both endpoint values. Option A uses > and < which are exclusive and would exclude 'Hansen' and 'Pettersen'. Option C has incorrect syntax with column names before FROM. The BETWEEN operator is the cleanest solution for range queries.

Keep practicing — related questions