What kind of join is join?



What kind of join is join?..

Answer / Rohit Kumar Bhadani

JOIN in SQL is a keyword used to combine two or more tables based on a related column between them. The most common types of joins are INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?

1 Answers  


what is the difference between $message and $$message? : Sql dba

1 Answers  


What is mdf ldf and ndf?

1 Answers  


Which join is like inner join?

1 Answers  


In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,


how to include numeric values in sql statements? : Sql dba

1 Answers  


What are inner outer left and right joins in sql?

1 Answers  


I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,


how to convert character strings to dates? : Sql dba

1 Answers  


Is microsoft sql free?

1 Answers  


what is the difference between union and union all

14 Answers   IBM, Luxoft, Oracle,


How to avoid duplicate records in a query?

1 Answers  


Categories