What is the order in which the SQL query is executed? list
them in order.

Answer Posted / selvam

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

561


How to use subqueries with the exists operators in ms sql server?

578


What method is used by the Command classes to execute SQL statements that return single values?

592


How to recover from sql injection? : sql server security

514


Explain Reporting Life Cycle?

90






What is the difference between sdf and mdf?

664


What is the difference between getdate and sysdatetime?

525


How network traffic be reduced by using the stored procedure?

576


Explain transaction isolation levels in sql server?

542


How does clustered and non clustered index work?

509


What is encryption key?

84


What are views in ms sql server?

589


How to Sync Two SQL Azure Databases?

101


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

645


What are the steps you should follow to start sql server in single-user mode?

474