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 differences between union, intersect, and minus operators?
What is clustered primary key?
query processing
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
How can you insert null values in a column while inserting the data?
What is measure group, measure? : sql server analysis services, ssas
Explain few examples of stored procedure over triggers?
Give me a SQL Query to find out the second largest company?
How to get nth highest salary from employee table.
How to set database to be read_only in ms sql server?
What are the differences between triggers and stored procedures?
What are basics of policy management?
What is a database in ms sql server?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to find the version of sql server? : sql server database administration