首页 > 试题广场 >

某杂志财务处为审稿人统计审稿费，已知审稿表view（审核编号

[单选题]

某杂志财务处为审稿人统计审稿费，已知审稿表view（审核编号vid，稿件编号mid，审核人编号rid，审核时间vtime，审核结果vresult），查询审核结果为60至80的稿件并按照审核人分组，下列语句正确的是（）

SELECT mid,vresult,rid
FROM view
WHERE vresult>=60 AND vresult<=80
GROUP BY rid

SELECT mid,vresult,rid
FROM view
WHERE vresult BETWEEN 60 AND 80
GROUP BY mid

SELECT mid,vresult,rid
FROM view
WHERE 60<=vresult<=80
GROUP BY rid

SELECT mid,vresult,rid
FROM view
WHERE vtime BETWEEN 60 AND 80
GROUP BY rid

查看答案及解析

这道题你会答吗？花几分钟告诉大家答案吧！

提交观点

问题信息

数据库

难度：

0条回答 2收藏 23浏览

扫一扫，把题目装进口袋