Answer / ramesh

The Concept of joining a table with it self in called "self
join"

Answer / shekar

the concept of joining a table with it self in called "self
join"

Answer / rrrrrrrrrr

The Concept of joining a table with it self in called "self
join"

Answer / gagan

Self join correlated rows of a table with other rows in the
same table.

Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10

What is indexing in sql server with example?

0 Answers  

---

How do you send email on SQL Server?

0 Answers   MindCracker,

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

---

---

what is maximum size of temp db?

4 Answers   iSoft,

---

How to create hyperlink from returned sql query ?

0 Answers   MCN Solutions,

---

What are clustered and non-clustered index?

0 Answers  

---

Explain throw statement in sql server 2008?

0 Answers  

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

0 Answers  

---

syntex of insert

7 Answers  

---

Define right outer join?

0 Answers  

---