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

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

What are the commands used in DCL?

0 Answers  

What are the built in functions in sql server?

0 Answers  

Why I have to use stored procedures?

0 Answers   Cognizant,

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

What is the difference between cross join and Full outer join?

1 Answers   HP, Standard Bank,

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

IN Vs OR operator which is best to use sql server.

4 Answers  

find the 3rd max salary

10 Answers  

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

can you any body tell me the difference between candidate key and primary key

4 Answers