SOLVED: A query uses both GROUP BY and HAVING. Which of the following statements is TRUE ...

A query uses both GROUP BY and HAVING. Which of the following statements is TRUE?

GROUP BY is used to filter data after the HAVING clause

HAVING can filter grouped data, whereas GROUP BY aggregates the data

HAVING must include all columns listed in GROUP BY

GROUP BY cannot work without a corresponding ORDER BY

Verified Answer

Correct Option - b

To get all Infosys Certified Oracle Database Administrator - Beginner Exam questions Join Telegram Group https://grateful.prepflix.in/infy-lex-pdfs