I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
- 4 Answers
- 8423 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / vijay_1994
Hi,
I have used left outer join
select
a,
b
from
tab1 ,
tab2
where
tab1.a = tab2.b(+);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I partition a table in sql?
Explain isolation levels. : Transact sql
What are the set operators in sql?
Can function return multiple values in sql?
How do you create a db file?
What do you understand by pl/sql packages?
what is cross join? : Sql dba
What is nosql vs sql?
what is 'mysqlshow'? : Sql dba
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
How do I save the results of sql query in a file?
What is a record in a database?
How do sql databases work?
What does (+) mean in sql joins?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
