Correct order execute of clauses in SELECT SQL statement?

Dung Do Tien Oct 19 2020 73

Which is the correct order of execution for statements in a select query? Below are some clauses please note for me order execution of them.

SELECT, FROM, TOP, WHERE, JOIN, ON, ORDER BY, GROUP BY, HAVING, DISTINCT.

Have 1 answer(s) found.
  • Below is the order execute of clauses above:

    1. FROM
    2. ON
    3. JOIN
    4. WHERE
    5. GROUP BY
    6. HAVING
    7. SELECT
    8. DISTINCT
    9. ORDER BY
    10. TOP
    Marry Christ Oct 19 2020
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Popular Tips