Oracle SQL clause evaluation order
Posted
by jon.johnson
on Stack Overflow
See other posts from Stack Overflow
or by jon.johnson
Published on 2010-05-16T01:07:57Z
Indexed on
2010/05/16
1:10 UTC
Read the original article
Hit count: 413
In Oracle, which clause types get evaluated first? If I had the following ( pretend .... represent valid expressions and relation names ), what would the order of evaluation be?
SELECT ...
FROM .....
WHERE ........
GROUP BY ...........
HAVING .............
ORDER BY ................
I am under the impression that the SELECT clause is evaluated last, but other than that I'm clueless.
© Stack Overflow or respective owner
