Question discussion

In a SELECT statement that uses WHERE, GROUP BY, HAVING and ORDER BY, which of these clauses is logically processed last?

1781Medium DSSSB TGT Computer Science 0 replies

In a SELECT statement that uses WHERE, GROUP BY, HAVING and ORDER BY, which of these clauses is logically processed last?

  • AWHERE
  • BORDER BY
  • CHAVING
  • DGROUP BY
Correct answer: B

Explanation

The logical order is FROM, WHERE, GROUP BY, HAVING, SELECT and finally ORDER BY, which sorts the result that has been produced.

Discussion 0

Nobody has replied yet. Start the discussion!