I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.

4 Answers   GE,

---

What is rownum?

0 Answers  

---

Does sql profiler affect performance?

0 Answers  

---

Why coalesce is used in sql?

0 Answers  

---

what is global variable in package

3 Answers   Polaris,

---

---

What is sqlite format?

0 Answers  

---

What is the importance of sqlcode and sqlerrm?

0 Answers  

---

what is denormalization. : Sql dba

0 Answers  

---

How can you fetch first 5 characters of the string?

0 Answers  

---

What are types of joins?

0 Answers  

---

Does SQL*Plus contains pl/sql Engine?

1 Answers   TCS,

---

what does the t-sql command ident_current does? : Transact sql

0 Answers  

---