Question of sql server

Question

One question that is asked in almost every interview about the steps involved in execution of sql query with example? Thanks in advance.

Tapan Patel · Answer

Here is the link with detailed information on How SQL server executes the query. http://rusanu.com/2013/08/01/understanding-how-sql-server-executes-a-query/

Bikesh Srivastava · Answer

Hi Order of execution When you execute a SQL Query it will be executed in the following sequence. FROM ON JOIN WHERE GROUP BY HAVING SELECT DISTINCT ORDER BY TOP