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 do you understand by data independence?
describe middleware applications that ease the connection of databases to web?
Which database is used by google?
What is rdbms and its types?
What is foreign key in database?
Explain what are the two types of oltp?
Which two can be implemented as a centrally located logical architecture?
What is a string in database?
How to move a multi-file database?
Does google have a database like access?
What are the characteristics of database management system?
Explain a tp monitor?