試題詳解

12. Which one is the actual execution order of the following statements in SQL?
[1] SELECT [DISTINCT]
[2] FROM
[3] WHERE
[4] GROUP BY
[5] ORDER BY
(A) SELECT, WHERE, GROUP BY, FROM, ORDER BY
(B) FROM, WHERE, GROUP BY, SELECT, ORDER BY
(C) FROM, WHERE, ORDER BY, SELECT, GROUP BY
(D) WHERE, FROM, ORDER BY, SELECT, GROUP BY
(E) WHERE, FROM, GROUP BY, SELECT, ORDER BY