1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the difference between join and natural join?

Question Posted / gaurava singh


What is the difference between join and natural join?..

Answer / Kaushal Kishor Meena

A Join specifies the columns to be used for matching records, while a Natural Join uses implicitly defined foreign key columns as the join condition.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are different sql data types?

1 Answers  

What is cross join sql?

1 Answers  

what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

how do you control the max size of a heap table? : Sql dba

1 Answers  

Why partition by is used in sql?

1 Answers  

how can we optimize or increase the speed of a mysql select query? : Sql dba

1 Answers  

Is sqlite free?

1 Answers  

What is record type in pl sql?

1 Answers  

what is myisam? : Sql dba

1 Answers  

What is mutating error in pl sql?

1 Answers  

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

For more SQL PLSQL Interview Questions Click Here
Categories