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
Do you know how to make remote connection in database?
What are the advantages of log shipping?
Can you use order by when defining a view?
Explain the different index configurations a table can have?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is difference in performance between insert top (n) into table and using top with insert?
What is the default port for SQL Server over a firewall?
Explain about extended stored procedure?
Mention the different types of replication in sql server.
What is dbcc?
What happens if the update subquery returns no rows in ms sql server?
What is report snapshot in ssrs?
In which format does an image save in SQL Server database ?
how to do partition in sqlserver
Explain a join?
