Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two table?
- 2 Answers
- 4933 Views
- iNautix, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / partha
There are two types of join inner join and outer join.
(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;
(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables
| Is This Answer Correct ? | 21 Yes | 0 No |
what is storage manager?
What do you understand by proactive, retroactive and simultaneous update?
What is entity relationship diagram?
What you know in mapping of erd to dfd?
When does checkpoint occur?
What is rdbms and its types?
Explain the three Level Architecture of the Database System
dear sir please provide what question will be asked in CWE in bank it officer
What is the difference between a catalog and a database?
What are the advantages of database?
Differentiate table scan from index scan.
What restrictions can you apply when you are creating views?
-
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)
