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

Answer Posted / ela tiku

At runtime the compiler first takes the table name from
where the data is to be retrieved (FROM <tablename>), then
it checks for the condition (Where <condition>) then it
selects the values to me displayed as o/p

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to avoid cursors? : Sql server database administration

486


In which sql server version report builder introduced?

105


What is the difference between writing data to mirrored drives versus raid5 drives

496


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

625


What do you mean by 'normalization'?

595






User wants only to display only pdf as export option in report manager. How to achieve this?

173


Explain mixed authentication mode of sql server?

539


What are the steps to insert a table?

537


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

114


What are security principals used in sql server 2005?

509


What are the types of database recovery models?

593


How to scale out a federation by Sql statement?

92


What function does a database engine serve in the sql server?

562


How to get the definition of a user defined function back?

558


How to resolve the orphan use problem? : sql server security

518