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
- 5433 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 pl sql data types?
What is primary key and foreign key with example?
How do I view tables in mysql?
Can pl sql procedure have a return statement?
Is hadoop a nosql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
How does a trigger work?
Can we create clustered index without primary key?
Write a sql query to get the third highest salary of an employee from employee_table?
Is null operator in sql?
what is online transaction processing (oltp)? : Sql dba
Can we join tables without foreign key?
What does pl sql developer do?
How do you write an inner join query?
How to return multiple rows from the stored procedure?
