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 many functions are there in sql?
Is it possible to create the following trigger: before or after update trigger for each row?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is sql profiling in oracle?
Is sql pronounced sequel or sql?
what is denormalization. : Sql dba
Why do we use view in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
What is ttitle and btitle?
Which normal form is best?
What is sql resultset?
What is composite primary key in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
what is view? : Sql dba
What is user defined functions?