> > >

Oracle 12c Admin MCQs

A production house needs a report about the sale, where total sale of the day is more than $20,000.Which query should be used?

0 select‘ from orders where sum(amount) > 20000;

0 select orderdate. sum(amount) from orders where sum(amount) > 20000 order by OrderDate;

0 select orderdate. sum(amount) from orders group by orderdate having sum(amount) > 20000;

0 select orderdate. sum(amount) from orders group by OrderDate where sum(amount) > 20000;

Answer

Correct Answer: 0 select orderdate. sum(amount) from orders group by orderdate having sum(amount) > 20000;

Explanation:

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

Oracle 12c Admin Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it