> > >

Oracle Database MCQs

How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500?

none of the above

select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;

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;

Answer

Correct Answer: select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Oracle Database Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it