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