Elance Exams Answers PDF file

-- PDF FILE --
Download PDF file of elance Zoho Creator Exam Answers
elance-zoho-creator-exam.pdf

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;
Top
  • Follows us our servcies
  • Facebook icon
  • Linkedin icon
  • twitter icon
  • rss icon
  • social icon