Interested to Buy Any Domain ? << Click Here >> for more details...
what are the different types of joins?
- 4 Answers
- 10681 Views
- Choice Solutions, I also Faced
- E-Mail Answers
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 primary key secondary key alternate key candidate key?
Does access use sql?
what is auto increment? : Sql dba
What is the difference between instead of trigger and after trigger?
How many commands are in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
What are the types of operators available in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
What is the cause of mutating table error and how can we solve it?
What is a common use of group by in sql?
What is difference between function and trigger?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What are the two types of exceptions.
What is the importance of sqlcode and sqlerrm?
what are the performance and scalability characteristics of mysql? : Sql dba
