Correct order execute of clauses in SELECT SQL statement?
Dung Do Tien Oct 19 2020 590
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.
- M-1
Marry Christ Oct 19 2020
Below is the order execute of clauses above:
- FROM
- ON
- JOIN
- WHERE
- GROUP BY
- HAVING
- SELECT
- DISTINCT
- ORDER BY
- TOP
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.