Interested to Buy Any Domain ? << Click Here >> for more details...
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
- 2 Answers
- 5326 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / krish
Using Intersect operator
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger in sql?
how many ways to get the current time? : Sql dba
Explain architecture of sql server notification services?
What is a Mapplet?
How many triggers can be applied to a table?
where are cookies actually stored on the hard disk? : Sql dba
What are the types of subqueries?
What is the difference between sql, mysql and sql server?
What is the reports view in oracle sql developer?
Explain the difference between 'between' & 'and' operators in sql
What is the requirement of self-join?
Is truncate ddl or dml?
What is the difference among union, minus and intersect?
Is left join inner or outer?
What is a trigger word?
