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,

---

Does sql between include endpoints?

0 Answers  

---

Is sqlite good enough for production?

0 Answers  

---

what is the difference between join and union? : Sql dba

0 Answers  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

What is duration in sql profiler trace?

0 Answers  

---

How many types of index are there?

0 Answers  

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

Why do we use procedures?

0 Answers  

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

Is sql better than excel?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---