Answer Posted / sangeetha meda
1. Self Join
Self join is a query in which a table is Joined to itself.
Self joins are used to compare the values in a column to
the other values in the same column in the same table.
2.Equi Join or Inner join
Equi join is a join in which the rows are retrieved the
equality of the relation ship between columns in the tables.
Select only those rows that have values in common in the
columns specified in the ON clause.
3.Non Equi Join or Outer Join
Left Outer Join:
Retrieves the matching records in both the table and non
matching records in the first or left table.
Right Outer Join
retrieves the matching records in both the table and non
matching records in the second or the right table.
Full Outer Join
Retrieves all the records (means matching and non matching
records in both the tables).
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is server name sql?
What is application trigger?
What is the use of triggers?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
What is trigger and types?
What is database white box testing and black box testing?
What is the maximum number of rows in sql table?
What is pivot in sql?
Explain the methods used to protect source code of pl/sql.
Is postgresql a nosql database?
What do you think about pl/sql?
What is row_number () in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
If a cursor is open, how can we find in a pl/sql block?
What is spool?
