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!!!
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:
Post a Comment