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
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to use subqueries with the exists operators in ms sql server?
What method is used by the Command classes to execute SQL statements that return single values?
How to recover from sql injection? : sql server security
Explain Reporting Life Cycle?
What is the difference between sdf and mdf?
What is the difference between getdate and sysdatetime?
How network traffic be reduced by using the stored procedure?
Explain transaction isolation levels in sql server?
How does clustered and non clustered index work?
What is encryption key?
What are views in ms sql server?
How to Sync Two SQL Azure Databases?
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?
What are the steps you should follow to start sql server in single-user mode?