题目内容

score 表中存储了学生的学号、期末成绩，如果需要查询期末成绩在85到90之间的学生及成绩，以下可以实现的是？

A. select studentno,finalfrom score where final between 85 and 90;
B. select studentno,finalfrom score where final between 85 and 91;
C. select studentno,finalfrom score where final between 84 and 90;
D. select studentno,finalfrom score where final>=85 and final<= 90;

查看答案

搜索结果不匹配？点我反馈

更多问题

查询sale_detail表的region为杭州地区和上海地区的所有记录，并将它们合并起来。下列语句可以实现的是？

A. Select * from sale detail where region= hangzhou'unionSelect * from sale detailwhere region = shanghai;
B. Select * from sale detail where region= 'hangzhou'union allSelect * from sale detail where region = shanghai;
C. Select * from sale_ detail where region='hangzhou' and region='shanghai";
D. Select * from sale detail where region in('hangzhou', 'shanghai');

查看答案