how to join two table?
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 are the types of Calculated columns available ?
What are procedures in database?
Define the following terms 19. (i) Database 20. (ii) Database Management System 21. (iii) Data Model 22. (iv) Scheme 23. (v) Data independence
What is the role of database server in database management system?
Why is rdbms important?
Why rdbms is called relational?
Where is data stored in database?
What are codd rules?
What is cold backup and hot backup (in case of oracle)?
Is driver a software?
What is a file in a database?
What is the advantage of the database management approach
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)