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

How to install sql server 2005 express edition?

0 Answers  

---

Can you name a few encryption mechanisms in sql server?

0 Answers  

---

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

---

How to defragment indexes with alter index ... Reorganize?

0 Answers  

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

---

What are dml triggers and types of dml triggers?

0 Answers  

---

Why do we use functions?

0 Answers  

---

Explain DBMS, RDBMS?

6 Answers  

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

What is wrong with sql server client libarary dll, ntwdblib.dll?

0 Answers  

---