Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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


...