Interested to Buy Any Domain ? << Click Here >> for more details...
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 pls_integer in pl sql?
what is the syntax for using sql_variant_property? : Transact sql
Where is all the data on the internet stored?
What is AUTH_ID and AUTH_USER in pl/sql ?
Can we join same table in sql?
What does closing a cursor do?
What is mutating sql table?
What port does sql server use?
What is on delete set null?
What is Materialized View? In What Scenario we Use Materialized View?
What is the difference between the conventional and direct path loader? : aql loader
What are pl sql data types?
Mention what are the benefits of pl/sql packages?
What is a full join?
What is sqlcommand?
