Interested to Buy Any Domain ? << Click Here >> for more details...
Give an example of Full Outer Join?
- 1 Answers
- 5589 Views
- IBM, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 3 Yes | 0 No |
How can I make sql query run faster?
What is a package ? What are the advantages of packages ?
how to do backup entire database? : Transact sql
What is crud sql?
Do we need commit after truncate?
what is the difference between a local and a global temporary table? : Sql dba
What is interval partition?
What is difference between cursor and ref cursor?
Why do we use procedures?
What is rank function in sql?
What is trigger in sql?
Explain the methods used to protect source code of pl/sql.
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
