Answer Posted / lakshminrayana reddy
5 types
1) Equi join
2) cartesian join
3) non-equi join
4)outer join(+)
i)left outer join
ii) right outer join
5)self join
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How do you write an index?
explain primary keys and auto increment fields in mysql : sql dba
How many disk partitions should I have?
How many subqueries can be nested in a statement?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
What is the difference between having and a where in sql?
How delete all records from table in sql?
What are the events on which a database trigger can be based?
What is a full join?
Explain the difference between triggers and constraints?
How do you add a column to a table?
Where is all the data on the internet stored?
Where not exists in sql?
What is delimiter in pl sql?
What is data type in sql?