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. 

Answers were Sorted based on User's Feedback



In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from tab..

Answer / krish

Using Intersect operator

Is This Answer Correct ?    0 Yes 0 No

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from tab..

Answer / oracle enthusiastic

The optimizer automatically decides the driving table based on statistics. The join order is immaterial

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What is sequence in sql?

0 Answers  


What is PL/SQL Records?

0 Answers  


How to write pl sql program in mysql command prompt?

0 Answers  


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  


What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,






What is the max nvarchar size?

0 Answers  


What is the difference between inner join and outer join?

0 Answers  


What do you understand by pl/sql packages?

0 Answers  


What are tables in sql?

0 Answers  


Describe types of sql statements?

0 Answers  


declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,


How do I order by ascending in sql?

0 Answers  


Categories