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
How to list all stored procedures in the current database using ms sql server?
What do I need to start working with sql studio? : sql server management studio
How to get a list of columns using the "sys.columns" view in ms sql server?
Is null in sql server?
What is use of except clause? How it differs from not in clause?
Can you import Microsoft Excel data to SSRS?
Difference between group by clause and having clause in SQL?
What is the difference between cartesian product and cross join?
What is the difference function and stored procedure?
What is catalog views?
Explain left outer join and right outer join?
What is clustered vs nonclustered index?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is a covering index?
What are the purpose of Normalisation?