查询Score表中成绩在60到80之间的所有记录,应使用的语句是________。
A SELECT * FROM score WHERE degree>=60&°ree<=80;
B SELECT * FROM score WHERE 60<=degree<=80;
C SELECT * FROM score WHERE degree BETWEEN 60 and 80;
D SELECT * FROM score WHERE degree IN(60,80);
A SELECT * FROM score WHERE degree>=60&°ree<=80;
B SELECT * FROM score WHERE 60<=degree<=80;
C SELECT * FROM score WHERE degree BETWEEN 60 and 80;
D SELECT * FROM score WHERE degree IN(60,80);