Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nikhila reddy
6. select top,ditinct,aggregations
steps to execute a query
1. from table1 joins table2
2. on condition
3. where condition
4. group by condition
5. having condition
7. orderby
these way we write the query,
while executing a query internally itwill puul data from table 1 and placed in temp1 as same table2 into temp2
result in temp3.then it checks where conditon and place in temp4 so on.........
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is a field in a table?
Do you know what are different types of replication in sql server?
What is meant by dirty read?
How to choose all records from the table?
What is the difference between a stored procedure and a user defined function?
What is sql injection and why is it a problem? : sql server security
What is #table in sql server?
What is model database? : SQL Server Architecture
What is query optimizer in sql server?
What is candidate key with example?
What the different components in replication and what is their use?
What are the types of lock supported by ?
Do you know how to send email from database?
How to access the deleted record of an event?
What do you mean by an execution plan? Why is it used?
