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

Answer / n

Inner and outer joins

What are the applications of database management system?

0 Answers  

---

What is Data Redundancy and Consistency ?

0 Answers   MCN Solutions,

---

What database does facebook use?

0 Answers  

---

What are the different file extensions that are created by Oracle ?

2 Answers  

---

select Nth highest salary by using rownum

4 Answers   Ford, TCS, Tech Mahindra,

---

---

What is dbms introduction?

0 Answers  

---

Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?

3 Answers   eBay,

---

Where is database data stored?

0 Answers  

---

What is a RADIO GROUP ?

1 Answers  

---

What is the importance of a database?

0 Answers  

---

What is Partial Backup ?

2 Answers  

---

Tell me about view, sequence and index in DBMS.

0 Answers   Honeywell, Zomato,

---