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

Determine when an index is appropriate?

0 Answers  

---

Equi join and non equi join is possible with sql server?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

What are the authentication modes in sql server? How can it be changed?

0 Answers  

---

How do you Implement SSIS Packages in your Project?

0 Answers  

---

How do I find the query plan in sql server?

0 Answers  

---

How to find the source of a table in sql server?

0 Answers  

---

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

0 Answers  

---

Explain where clause?

0 Answers  

---

What are indexes in ms sql server?

0 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

Can foreign key be deleted?

0 Answers  

---