如何通过 SQL 从 Persons 表中找出 LastName 字段的值在 Hansen(包含) 和 Pettersen 之间的所有记录?

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

选择了： SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

选择了： SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'