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
What is a database in computer?
What is string in database?
How is data stored in a relational database?
What are the benefits of modeling?
What is user and end user?
Define transaction and transaction isolation levels?
Which free database is best?
What is the best database for big data?
Who is communication horizons?
What is order by clause?
Why are recursive relationships are bad? How do you resolve them?
What is the 3-tier architecture?
How to retrive a single data from a database
Explain the term entity set in dbms?
What do you understand by cursor? Mention the different types of cursor?
