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
- 9718 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
Where not exists in sql?
How can you view the errors encountered in a trigger?
How much does a sql dba make? : SQL DBA
what are properties of a transaction? : Sql dba
What is pl sql in oracle?
Why do we use triggers?
how to load data files into tables with 'mysqlimport'? : Sql dba
How many types of indexes are there in sql?
Why do we create views in sql?
Inline the values in PL/SQL, what does it mean.?
What is example of database?
What is prepared statement in sql?
what is a primary key? : Sql dba
Is stored procedure faster than query?
What is sqlerrm?
