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
- 8422 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / anil
I prefer full outer join MINUS inner join.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
What is the difference between the sql*loader and import utilities? : aql loader
How to rename a column in the output of sql query?
What is forward declaration in pl sql?
Explain the working of primary key?
What do you mean by stored procedures? How do we use it?
What are different types of sql?
What is dynamic sql in pl sql?
How do I run a program in pl sql?
What is meant by user defined function?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
Explain locks? : Transact sql
What is raw datatype in sql?
What are the different parts of a package?
What is orm in sql?
