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 are the extra roles available in msdb? : sql server security
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is difference between views and stored procedures?
What is the difference between DATETIME2 and DATETIME?
What do you mean by an execution plan?
What are the joins in sql server? : sql server database administration
Which are the third-party tools used in sql server and why would you use them?
What are the drawbacks of reporting in ssrs?
Mention the 3 ways to get a count of the number of records in a table.
What is the stuff and how does it differ from the replace function?
Explain what is scheduled job and how to create it?
what is a correlated sub-query? : Sql server database administration
What are the purposes of floor and sign functions?
What is a view in sql?
What is row_number () and partition by in sql server?
