1.Self Join 2.Inner Join i.Equi-Join ii.Non-Equi Join 3.Outer Join

Types of joins ?

Question Posted / siva

Answer Posted / siva

1.Self Join
2.Inner Join
i.Equi-Join
ii.Non-Equi Join
3.Outer Join
i.Full Outer Join
11.Left Outer Join
iii.Right Outer Join

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain locks? : Transact sql

575

how can we find the number of rows in a table using mysql? : Sql dba

586

what is 'mysqlcheck'? : Sql dba

575

How do you define a foreign key?

537

What are sql functions? Describe the different types of sql functions?

560

Can we use ddl commands in pl sql?

559

The select into statement is most often used to create backup copies of tables or for archiving records?

561

Can we delete column in sql?

563

what are the nonstandard string types? : Sql dba

608

How do you create a unique index?

573

what is an extent ? : Sql dba

584

What are all the different normalization?

562

What is the starting oracle error number? What is meant by forward declaration in functions?

543

What is trigger in sql? Explain

538

how to increment dates by 1 in mysql? : Sql dba

541