In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

How do you rename a table in sql?

0 Answers  

---

Which type of cursor is used to execute the dml statement?

0 Answers  

---

What are triggers and its types?

0 Answers  

---

what is timestamp in mysql? : Sql dba

0 Answers  

---

What is difference sql and mysql?

0 Answers  

---

What is pls_integer in pl sql?

0 Answers  

---

why not null constraint showing its constraint type as 'c'

1 Answers  

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

How exception is different from error?

0 Answers  

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---