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

What are the differences between union, intersect, and minus operators?

1064

---

What is clustered primary key?

996

---

query processing

2144

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

962

---

How can you insert null values in a column while inserting the data?

1251

---

What is measure group, measure? : sql server analysis services, ssas

994

---

Explain few examples of stored procedure over triggers?

1012

---

Give me a SQL Query to find out the second largest company?

1150

---

How to get nth highest salary from employee table.

1149

---

How to set database to be read_only in ms sql server?

981

---

What are the differences between triggers and stored procedures?

1038

---

What are basics of policy management?

1084

---

What is a database in ms sql server?

1038

---

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2728

---

How to find the version of sql server? : sql server database administration

1088

---