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 sql dialect?
What is bind reference and how can it be created?
What is the difference between count 1 and count (*) in a sql query?
How do I create a sql script?
What is serial sql?
How do you go back in sql?
What is the difference between partition and index?
How many sql commands are there?
what is cross join? : Sql dba
Does a primary key have to be a number?
Write a sql query to convert all character to uppercase after hypen.
Is mariadb nosql?
What does dml mean?
What is difference between mysql and postgresql?
What are schema-level triggers?