What are the different types of joins and explain them
briefly.
Answer Posted / hindol
equi join ,
non-equi join,
self join,
outer join,
cross join.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is trigger and types?
What is sqlerrd?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
What is primary key and unique key?
what is a relationship and what are they? : Sql dba
Can you upgrade sql express to full sql?
What is primary key and foreign key with example?
What is embedded sql with example?
Why do we use joins?
Explain dml and ddl?
what is difference between delete and truncate commands? : Sql dba
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 cursor status?
what is the difference between char and varchar data types? : Sql dba
Is a view faster than a stored procedure?