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
- 8424 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / rizaul
I have used inner joins
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the different types of constraints?
what are string data types? : Sql dba
What are sql*plus environment variables?
What is trigger and stored procedure in sql?
Explain the order of sql statement execution?
What is the maximum number of columns in sql table?
Which is better varchar or nvarchar?
What is the benefit of foreign key?
What will you get by the cursor attribute sql%found?
Are subqueries faster than joins?
What is multiple partition?
How to install oracle sql developer?
what tools available for managing mysql server? : Sql dba
How do rank () and dense_rank () differ?
What can I use instead of union in sql?
