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

Can a synonym name of a table be used instead of a table name in a select statement?

768


When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

701


What are a scheduled jobs or what is a scheduled tasks?

653


What is a covered index?

707


Explain about analysis services?

757






Explain alternate key, candidate key and composite key in sql server?

658


How can we determine what objects a user-defined function depends upon?

694


What is data source in connection string?

641


What are audit control procedures?

749


What is the contrast amongst drop and truncate?

755


What do you mean by subquery?

746


Explain the working of sql privileges?

797


What does it mean to manipulate data?

743


How to skip remaining statements in a loop block using continue statements?

743


What do you mean by acid?

758