What is meant by Join? What are the different types of
Joins available? Explain.
Answer Posted / mahesh
joins are used to relate two tables and display the result..
Types of join
1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is datawarehouse? : Sql dba
Are dml statements autocommit?
What is primary key secondary key alternate key candidate key?
How to get list of all tables from a database?
how to convert character strings to numeric values? : Sql dba
what is union, minus and interact commands? : Sql dba
What is duration in sql profiler trace?
Explain the select statement in sql?
What is replication id?
What is meant by <> in sql?
How to fix oracle error ora-00942: table or view does not exist
How do you declare a variable in pl sql?
Explain 3 basic parts of a trigger.
what is row? : Sql dba
Mention what problem one might face while writing log information to a data-base table in pl/sql?