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 are the different types of dbmss?

0 Answers  

---

What are the different sql commands?

0 Answers  

---

What is normalization sql?

0 Answers  

---

What is a stored procedure in sql with example?

0 Answers  

---

---

How can I delete duplicate rows?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

What normalization means?

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

What is the non-clustered index in sql?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

6 Answers   CGI,

---