Hi Jeff ; Thank you for sharing this informative tutorial; Can I ask you a question kind of basic question in oracle This below, what I know Logical query processing order for T SQL server from microsoft ; is it the exact same for Oracle or any other Relational Database; or it differs in case of Oracle. 1. FROM 2. ON 3. JOIN 4. WHERE 5. GROUP BY 6. WITH CUBE/ROLLUP 7. HAVING 8. SELECT 9. DISTINCT 10. ORDER BY 11. TOP 12. OFFSET/FETCH Thank ful for any advice
there's the syntactical order those statements are expected in...and there's the order of operations undertaken by the database engine/optimzier to make your query results available if you look at an Execution Plan for your SQL, this might help you
