SOLVED: If a query uses both GROUP BY and ORDER BY, which operation is performed FIRST? ...

If a query uses both GROUP BY and ORDER BY, which operation is performed FIRST?

ORDER BY is performed before GROUP BY

GROUP BY is performed before ORDER BY

Both are performed simultaneously

The execution order depends on the database engine

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