Sunday, December 18, 2011

Sequence of execution of SQL querry

Sequence of execution of SQL querry is discussed below which is so helpful to design a query if you are handling large DB results.

1. FROM
2. JOIN
3. ON
4. WHERE
5. GROUP BY
6. HAVING
7. SELECT
8. DISTINCT
9. ORDER BY
10. LIMIT (TOP)

Enjoy Programming!!!

No comments: