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

Answer Posted / suraj

Though it's not so clear on what type of SQL query.
If we want to see in what order does the SELECT query
executes; it'l like this.

SELECT .........
FROM ..........
WHERE ..........
GROUP BY ...........
HAVING ............

Is This Answer Correct ?    6 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List the different types of joins?

550


How do users use Report Builder with SQL Server data sources?

111


How do you check sql server is up and running?

492


How to list all schemas in a database?

550


Can you create a logon trigger in sql server 2005 express edition?

549






How do you size a resultset?

475


What are the different ways you can create databases in sql server?

544


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

541


Why I am getting this error when renaming a database in ms sql server?

511


What is a view and what are its advantages?

664


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

873


What is a subquery in a select query statement in ms sql server?

558


what is the information that can be stored inside a bit column? : Sql server database administration

496


How to optimize stored procedures in sql server?

598


What are the types of joins in sql?

537