Answer / senthil kumar

6. full outer join : ALL UNMATCHED DATA FROM BOTH TABLES

SELECT * FROM TABLE A FULL OUTER JOIN TABLE B ON (A.ID= B.ID)
Ex:

TABLE A
NO NAME 1 X
2 Y
5 Z

TABLE B
NO NAME 1 XX
2 YY
3 ZZ
4 AA

OUTPUT:
NO NAME NO NAME
1 X 1 XX
2 Y 2 YY
3 ZZ
4 AA
5 Z

How delete all data from all tables in sql?

0 Answers  

---

Can you selectively load only those records that you need? : aql loader

0 Answers  

---

Can delete statement be rollbacked?

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

What is a table in a database?

0 Answers  

---

---

Describe different types of general function used in sql?

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

Explain the usage of WHERE CURRENT OF clause in cursors ?

3 Answers  

---

Can a table have no primary key?

0 Answers  

---

why we go for package? what are the advantages of using instead of seperate procuderes or functions

3 Answers   IBM, TCS,

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

1 Answers  

---

How to write a query to show the details of a student from students table whose

0 Answers  

---