Select from following answers:- SELECT , DISTINCT, FROM, WHERE
- FROM, WHERE, SELECT, DISTINCT
- DISTINCT, SELECT, WHERE, FROM
- WHERE, DISTINCT, FROM, SELECT
- All Above
Query execution order is determined by SQL Server to improve the performance. Normally for SELECT query in the following order only be executed.
FROM,ON,JOINS,WHERE,GROUP BY, CUBE|ROLLUP, HAVING, SELECT, DISTINCT,ORDER BY and TOP. It is the prescribed order. But some times depending on the complexity of the query SQL will follow its own order for better performance.
Show Correct Answer
Asked In: Ramco Systems |
Alert Moderator