Answer Posted / 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

What is consistency?

1060

---

What are the 3 types of behavioral triggers?

1181

---

what is the difference between myisam static and myisam dynamic? : Sql dba

1001

---

What does where 1/2 mean in sql?

1006

---

What is cold data?

895

---

How to find 3rd highest salary of an employee from the employee table in sql?

1034

---

What is a temporal data type?

974

---

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

983

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

952

---

How do I truncate a word?

986

---

What is primary key secondary key alternate key candidate key?

977

---

What are the main features of cursor?

1038

---

What is cartesian join in sql?

1027

---

Is big data nosql?

881

---

What are schema-level triggers?

1038

---