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
- 4046 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 execute immediate?
What is cte?
Can we rename a column in the output of sql query?
How do you write an inner join query?
What is sql query optimization?
How to call shell script from pl sql procedure?
What is a dirty read sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
What are sql injection vulnerabilities?
What are % type and % rowtype?
What do you mean by dbms? What are its different types?
What are the different types of triggers?
What is nvl?
When can we use the where clause and the having clause?
What is percent sign in sql?
