self joins,natural joins,cross joins,inner joins,outer joins,equi and non

Types of joins?

Question Posted / mohana sundaram

Answer Posted / mohana sundaram

self joins,natural joins,cross joins,inner joins,outer
joins,equi and nonequi joins.

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What type of database is cloud sql?

1095

Is subquery faster than join?

1009

Write a sql query to find the names of employees that begin with ‘a’?

1011

Is sqlite thread safe?

1044

Will truncate release space?

943

what are null values? : Sql dba

951

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1118

What are stuff and replace function?

1076

Can we write ddl statements in functions?

1112

Explain raise_application_error.

1089

Can we rollback truncate?

998

what is recursive stored procedure? : Sql dba

984

What is primary key and foreign key?

958

What are transaction and its controls?

1037

Why do we use %rowtype & %type in plsql?

1046