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

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  

---

What is Difference Between delete and Truncate?

9 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

---

Enlist some predefined exceptions?

0 Answers  

---

What are the different set operators available in sql?

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

What is meant by temporal data?

0 Answers  

---

If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?

9 Answers   JPMorgan Chase,

---

What is inner join in sql?

0 Answers  

---

Which are the most commonly used sql joins?

1 Answers  

---