Answer / s.chithiravelu

Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.

Various Types of Joins:

Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins

Answer / hari

Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join

How to find Duplicate Records In table?

0 Answers   HCL,

---

when would you go for denormalization? : Sql server database administration

0 Answers  

---

Explain transaction server isolation?

0 Answers  

---

What are the components of dbms?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

Explain system scalar functions?

0 Answers  

---

what are batch in sql server?

2 Answers   Satyam,

---

Is truncate a dml command?

0 Answers  

---

What is the difference between rank and dense_rank?

0 Answers  

---

What is an indexing strategy?

0 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

---