Organizational Research By

Surprising Reserch Topic

oracle sql clause evaluation order


oracle sql clause evaluation order  using -'sql,oracle,clause,order-of-evaluation'

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.
    
asked Sep 21, 2015 by rajesh
0 votes
5 views



Related Hot Questions



Government Jobs Opening


...