Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9947 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
what is index? : Sql dba
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How do I remove duplicates in two columns?
What is the difference between nested table and varray?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what are different types of keys in sql?
Can we use ddl statements in stored procedure sql server?
What are tuples in sql?
How to place comments in pl/sql?
How many types of functions are there in sql?
What is not null in sql?
Is it possible for a table to have more than one foreign key?
What is exit statement?
What is query optimization in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
