What is a join?Explain the different types of joins?
- 6 Answers
- 30989 Views
- Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / pratap
Joins are the methods used to access related data from one
or more tables. there are five types of join
1. Equi join(i.e. Inner join)
2. self join
3. left join
4. right join
5. outer join
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
what is isam? : Sql dba
What are sql queries used for?
Which software is used for pl sql programming?
What is cursor and its types?
What is the trigger in sql?
What is a boolean in sql?
What normalization means?
what is a stored procedure? : Sql dba
What is clustered index sql?
What is the use of function in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the qualities of 2nf?
How do you select unique values in sql?
What is the difference between count 1 and count (*) in a sql query?
How do I view tables in mysql?
