测验中分数在80到100之间的候选人需要面试,合适的查询语句是
A.
SELECT vFirstName,vLastName,siTestScore FROM ExternalCandidate WHERE siTestScore>=80 AND siTestScore<=100< span="">
B.
SELECT vFirstName,vLastName,siTestScore FROM ExternalCandidate WHERE siTestScore>80 AND siTestScore<100< span="">
C.
SELECT vFirstName,vLastName,siTestScore FROM ExternalCandidate WHERE siTestScore<=80 and="" sitestscore="">=100
D.
SELECT vFirstName,vLastName,siTestScore FROM ExternalCandidate WHERE siTestScore<80 and="" sitestscore="">100