Interested to Buy Any Domain ? << Click Here >> for more details...
how to join two table?
- 2 Answers
- 4900 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 |
Is dynamodb a document database?
Where is the data stored in a database?
What is primary key in database?
Why indexing is used in database?
What is use of dbms?
What is the importance of a database?
What is the use of IGNORE option in IMP command ?
What is tuple in rdbms?
Is declare cursor executable?
What is father dbms?
What are the properties of a primary key in DBMS?
0 Answers HAL, Honeywell, Zomato,
What is big data in database?
-
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)
