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

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

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..

Answer / selvam

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

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 ............

What is correlated subquery in sql server?

0 Answers  

How to send email from database?

0 Answers  

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

What is statement level trigger?

0 Answers  

Define self join?

0 Answers  

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

Is sql different from sql server?

0 Answers  

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

Can a rule be bound to any column of any data type?

0 Answers  

What is the default port for SQL Server over a firewall?

0 Answers   Microsoft,

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,