Answer Posted / 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 |
Post New Answer View All Answers
How a Store Procedure called with a cursor out parameter.?
What do you mean by buffer manager?
What is the definition of database management system?
What is type of end users?
What is key dbms?
What are its two major subsystems of r?
What is dbms and its advantages?
What is alternate key?
How to stop superserver service on linux using only firebird tools?
Does google have a database program?
Explain database partitioning and its importance.
What is the difference between shrink database and shrink file?
Explain atomicity and aggregation?
What is Database testing and What are ways of writing test cases for database testing?
What is sql in database management system?