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.
Answer Posted / geeta
select * from tab1
union
select * from tab2;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What will you get by the cursor attribute sql%found?
What is the difference between Union and Union all. Which is faster.
How long will it take to learn pl sql?
Is t sql a programming language?
How can I delete duplicate rows?
what are the security recommendations while using mysql? : Sql dba
What are the different types of joins in sql?
Write a unique difference between a function and a stored procedure.
How much does sql cost?
How do I make sql search faster?
What is sql indexing?
When is a declare statement required?
what is an alias command? : Sql dba
what is a record in a database ? : Sql dba
Why do we use subquery?