首页 > 试题广场 >

Which of the following queries

[单选题]
Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500? 
  • select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;
  • select job, sum(sal) from emp where comm is null group by job having
sum(sal) > 2500;
  • select job, sum(sal) from emp where sum(sal) > 2500 and comm is null
group by job;
  • select job, sum(sal) from emp group by job having sum(sal) > 2500 and
comm is not null;
查看正确选项
添加回答

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

提交观点

问题信息

2017 算法工程师 大数据开发工程师 paypal
上传者：小小
难度：
0条回答 546浏览

热门推荐

相关试题

扫一扫，把题目装进口袋

求职之前，先上牛客

扫描二维码，进入QQ群

扫描二维码，关注牛客公众号