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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / nandkumar karlekar

The order of Execution is as follows
1.From clause and joins
2.independent subqueries in the where clause
3.where clause last condition execute first but if the
index is present then these condiyions execute first

Is This Answer Correct ?    3 Yes 0 No

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

Answer / l. meher

When a SQL query is getting executed it goes through the
following steps:

1) It goes to the shared pool which contains information
such as the parse tree and execution plan for the
corresponding statement.
2)Validate the SQL statement.
3)Validate the source.
4)Acquire locks.
5)Checks for previllages.
6)Parse the statement.
7)Execute the Query.
8)Fetch the value (only for select statement).
9)Generate the redo information.

If you have any doubt mail me at lmeher.tcs@gmail.com
Thanks..

Is This Answer Correct ?    5 Yes 4 No

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

Answer / selvam

FROM
ON
JOIN
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
ORDER BY
TOP

Is This Answer Correct ?    1 Yes 0 No

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

Answer / 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

More SQL Server Interview Questions

What are the different types of replication are there in sql server 2000?

0 Answers  


what protocol both networks use? : Sql server database administration

0 Answers  


What are the types of subquery?

0 Answers  


What is row-level compre?

0 Answers  


How to call stored procedure using http soap?

0 Answers  






After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,


How to send email from database?

0 Answers  


why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  


Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  


What is amo? : sql server analysis services, ssas

0 Answers  


What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,


how to find out the repeated value from table using groupby function?

4 Answers  


Categories