Answer Posted / sreekanth

Basically there are 5 types of joins, they are

1.Equi join
2.Non-equi join
3.cartegian join
4.outer join(+)>>a)left outer join
b)right outer join
5.self join

what is sql server agent? : Sql dba

1176

---

what is schema? : Sql dba

1137

---

How do I remove duplicates in two columns?

1177

---

define sql insert statement ? : Sql dba

1094

---

Does group by remove duplicates?

1112

---

what are the advantages of sql ? : Sql dba

1137

---

what are all the common sql function? : Sql dba

1125

---

how to escape special characters in sql statements? : Sql dba

1110

---

What is the best sql course?

1046

---

What is your daily office routine?

2340

---

how to use regular expression in pattern match conditions? : Sql dba

1105

---

Do we need to rebuild index after truncate?

1128

---

what is dbms? : Sql dba

1061

---

What is the current version of postgresql?

1168

---

Can delete statement be rollbacked?

1050

---