Which Of The Following Queries Displays The Sum Of All Employee #632
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?
This multiple choice question (MCQ) is related to the book/course
gs gs117 Database Management System.
It can also be found in
gs gs117 Database Programming Techniques - Rapid Application Development - Quiz No.1.
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;
Similar question(s) are as followings:
Online Quizzes of gs117 Database Management System
Indexing and Hashing - Bitmap Indices - Quiz No.1
gs gs117 Database Management System
Online Quizzes
