Interested to Buy Any Domain ? << Click Here >> for more details...
What is a join?Explain the different types of joins?
- 6 Answers
- 33897 Views
- Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / sandeep verma
Join match/combine two or more tables from a database. It means, combining rows or fields of two or more tables matching the common values. There are various types of joins which are as follows:
a) Self Join: joining table with it's own record to extract unique record (one employee is manager of other two employee)
b) Inner Join
i) Equi Join:No difference with inner join (just write join instead of inner join)
ii) Cross Join: will get you result each row of first table with each row of the other table(i.e. select * from employee cross join salary)
c) Outer Join
i) Left Outer Join:joins the matching records from two tables and all the records from left side of the table and those unmatched records have null value in right side of the table.
ii) Right Outer Join:joins the matching records from two tables and all the records from right side of the table and those unmatched records have null value in left side of the table.
iii) Full Outer Join: Regardless of matching record of both side of the tables, it produce all the records of both the table and produce NULL values for every column of the table that lacks of matching row.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a sql*loader control file?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
what is a materialized view? : Sql dba
What is the difference between count 1 and count (*) in a sql query?
Why indexing is needed?
What is difference between db2 and sql?
Can we use insert statement in function?
How many types of privileges are available in sql?
Explain what is a field in a database and record in a database?
Is pl sql a programming language?
What is sql in oracle?
What is the difference between the conventional and direct path loader? : aql loader
What are the parts of a basic sql query?
Explain what is a view?
Is crud a cuss word?
