Interested to Buy Any Domain ? << Click Here >> for more details...
Give an example of Full Outer Join?
- 1 Answers
- 5509 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 |
What is exception? What are the types of exceptions?
What is the difference between delete, truncate and drop command?
What is a join?Explain the different types of joins?
6 Answers Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,
What does (+) mean in sql joins?
How do I remove sql developer from windows 10?
Explain unique key in sql.
How many databases can sql express handle?
What is partition in sql query?
what are date and time functions in mysql? : Sql dba
How can you create Cursor with parametres ?
What is vector point function?
What is auto increment in sql?
-
Oracle (3259) - 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)
