题目: 通过 SQL,您如何按字母顺序选取 Persons 表中 LastName 介于 Adams 和 Carter 的所有记录?
选项:
A.SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
B.SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
C.SELECT LastName>'Adams' AND LastName<'Carter' FROM Persons
这道题目应该怎样理解呢?请大虾们赐教,谢谢!
选项:
A.SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
B.SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
C.SELECT LastName>'Adams' AND LastName<'Carter' FROM Persons
这道题目应该怎样理解呢?请大虾们赐教,谢谢!
B语句要加 >= and <=
A.SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
LastName中Adams与Carter之间的数据~含两者也可以看成
SELECT * FROM Persons WHERE LastName>='Adams' AND LastName<='Carter' B.SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
LastName中Adams与Carter之间的数据~不含两者 C.SELECT LastName>'Adams' AND LastName<'Carter' FROM Persons
语法错误
A语句:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
B语句:SELECT * FROM Persons WHERE LastName>='Adams' AND LastName<='Carter'-- 上面A、B语句是相等滴!
您的回答:SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'正确答案:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'