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
- 8429 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / geeta
select * from tab1
union
select * from tab2;
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How does index help in query performance?
How can I delete duplicate rows?
Can we use joins in subquery?
What are the different ddl commands in sql?
write an sql query to find names of employee start with 'a'? : Sql dba
What does partition by mean in sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is a sql trace file?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is the meaning of disabling a trigger?
Is grant a ddl statement?
What is a left inner join?
Is sqlite thread safe?
Is sql dba a good career? : SQL DBA
what is the difference between group by and order by in sql? : Sql dba
