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 assign new column names in a view?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

What do you mean by subquery?

0 Answers  

---

How secure is sql server database?

0 Answers  

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

What function does a database engine serve in the sql server?

0 Answers  

---

How do I compare two values when one value(data type) is char and the other is an integer?

3 Answers  

---

How to connect a database with sql express.?

0 Answers   MCN Solutions,

---

Do you know how to store and query spatial data?

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

Explain time data type in sal server 2008?

0 Answers  

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---