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
- 8741 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
What is the use of double ampersand (&&) in sql queries? Give an example
What is %rowtype in pl sql?
What are the properties of a transaction?
what is difference between delete and truncate commands? : Sql dba
What is the mutating table and constraining table?
what is the command line end user interface - mysql? : Sql dba
What is set serveroutput on?
Do we need commit after truncate?
what is a constraint? : Sql dba
Is mariadb a nosql database?
Does truncate free space?
What is a table partition?
What is scope of pl sql developer in future?
What is view explain with example?
what is the difference between delete and truncate statement in sql? : Sql dba
