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
- 4099 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 are the 3 types of behavioral triggers?
Can a table have no primary key?
What is sqlcommand?
Is sql sequential or random?
What is the use of partition by in sql?
How you improve the performance of sql*loader? : aql loader
What is scalar and vector?
Can you select everything, but 1 or 2 fields, without writer's cramp?
What is replication id?
What is sql partition?
What does the hierarchical profiler does?
What are sql objects?
Explain the advantages and disadvantages of stored procedure?
what is subquery? : Sql dba
when MSQL8.0 is in market
