在SQL Server中,查询Persons表所有列,并按LastName列字母顺序排序,过滤LastName介于Hansen和Pettersen之间数据,正确的SQL语句是?( )
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'