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 different types of statements supported by sql?

0 Answers  

---

How do I view stored procedures?

0 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

What is ROWID?

8 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What is the advantage of index in sql?

0 Answers  

---

How do I remove duplicates in two columns?

0 Answers  

---

What is database sql?

0 Answers  

---

Explain what is table in a database?

0 Answers  

---

What is pl/sql tables?

7 Answers   TCS,

---

What is difference between inner join and cross join?

0 Answers  

---