Answer / chandra rekha

Types of joins:
->Inner join
->Outer join->1.Left Outer join
2.Right Outer join
->Cross join
->Equi join
->Natural join
->Self join

Outer join:-When we need all rows from one table and some
rows from the other table

Self join:-When one row in a table correlated with other
rows in the same table

Answer / shivanibehere

For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921

Answer / shivanibehere

http://www.tomjewett.com/dbdesign/dbdesign.php?
page=jointypes.php&imgsize=medium

How does recursive cte works in sql server?

0 Answers  

---

What are different backups available in sql server?

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security

0 Answers  

---

what is the output for this query select * from employee where 1=1;

4 Answers  

---

---

What is field in algebra?

0 Answers  

---

syntax and example for bitmap index in sql???

1 Answers  

---

How to handle errors in Stored Procedures.

2 Answers   Accenture,

---

What are the different normalization forms?

0 Answers  

---

What are the advantages of stored procedure in sql server?

0 Answers  

---

Explain the use of containers in ssis?

0 Answers  

---

How do you optimize Sql queries ?

0 Answers   Cognizant,

---