Sunday 25 August 2013

What is the Execution Flow of a SQL QUERY?

What is the flow of Execution of a SQL QUERY?

1.    FROM clause
2.    WHERE clause
3.    GROUP BY clause
4.    HAVING clause
5.    SELECT clause
6.    ORDER BY clause

If we write the sql Query in SQL Editor. The Execution Flow is:   

            First Execute From Clause

                        Then Where Clause

                                    Then Group By Clause            
                                                                                                            
                                                Then Having Clause

                                                            Then Select Clause

                                                                        Order By Clause

0 comments: