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.
Answers were Sorted based on User's Feedback
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 |
I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?
What are the operators used in select statements?
How can I get the number of records affected by a stored procedure?
Which table is left in left join?
What is autocommit sql?
what is the difference between trigger and constraint?
What is the difference between sql and mysql?
what is query cache in mysql? : Sql dba
How to convert comma separated string to array in pl/sql?
Explain how can you save or place your msg in a table?
what is table? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?