what are the different types of joins?
Answer Posted / a.jyothsna
1)Self Join
2)Equi join (or)Inner Join
2.1)Non-equi Join
3)Outer Join
3.1) Left-Outer Join
3.2) Right-Outer Join
3.3) Full-Outer Join
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
What is sqlexception in java?
How can you select unique records from a table?
What is a call statement? Explain with an example.
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
In what condition is it good to disable a trigger?
How do I add a database to sql?
What is dialect in sql?
What is nvarchar in sql?
Explain normalization and what are the advantages of it?
Can you do multiple joins in sql?
what does the t-sql command ident_incr does? : Transact sql
what is query cache in mysql? : Sql dba
How is debugging done?
Can we commit in trigger?
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?