通过 SQL,您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 的所有记录?
您的回答:SELECT LastName>'Adams' AND LastName<'Carter' FROM Persons
正确答案:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
您的回答:SELECT LastName>'Adams' AND LastName<'Carter' FROM Persons
正确答案:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'