Answer / Robin Gupta

A self join in SQL Server, also known as reflexive join, is a type of JOIN operation where a table is joined with itself. It allows you to compare or combine rows from the same table based on common column values. The syntax for a self join includes aliases to distinguish between the two occurrences of the table.

Explain database normalization?

1 Answers  

---

what is database replicaion? : Sql server database administration

1 Answers  

---

How to turn on the mssql api module in php?

1 Answers  

---

What are commonly used odbc functions in php?

1 Answers  

---

What is nonclustered index with included columns ?

1 Answers  

---

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

2 Answers  

---

What does the INSTEAD OF trigger do?

3 Answers  

---

what is sql server? : Sql server database administration

1 Answers  

---

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

---

What are rows and columns?

1 Answers  

---

What are different backups available in sql server?

1 Answers  

---

why would you call update statistics? : Sql server database administration

1 Answers  

---