通过 SQL,按字母顺序选取 Actor 表中 LastName 介于 Adams 和 Carter 的所有记录的表述正确的是()。
A.SELECT * FROM Actor WHERE LastName BETWEEN 'Adams' AND 'Carter'
B.SELECT * FROM Actor WHERE LastName>'Adams' AND LastName<'Carter'
C.SELECT LastName>'Adams' AND LastName<'Carter' FROM Actor
D.SELECT * FROM Actor WHERE LastName>'Adams' OR LastName<'Carter'