What is a join?Explain the different types of joins?
- 6 Answers
- 30889 Views
- Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / lakshminarayana reddy
used to retrieve desired data from more than 1 table we use
join.
joins types:- 1.Equi join
2.non-Equi join
3.outer join
4.Self join
| Is This Answer Correct ? | 10 Yes | 7 No |
Post New Answer View All Answers
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
explain mysql aggregate functions. : Sql dba
Which is better stored procedure or query?
How do I start sql profiler?
What is denormalization in a database?
How to select all records from the table?
What is group function in sql?
what is msql? : Sql dba
What is clustered and nonclustered index in sql?
What is acid property in a database?
what is text? : Sql dba
Explain spool.
which types of join is used in sql widely? : Sql dba
Why do we need databases?
How to start oracle sql developer?
