Correct order execute of clauses in SELECT SQL statement?
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.
Marry Christ Oct 19 2020
Below is the order execute of clauses above:
- GROUP BY
- ORDER BY