Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 table A and B. In A 1 lakh record is present. In b 20 thousand data is present. To get the unique data from table A and B which join we should prefer left inner join or right outer join. Please answer.
- 4 Answers
- 10120 Views
- GE, I also Faced
- E-Mail Answers
Answer Posted / rizaul
I have used inner joins
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are tables in sql?
what happens if you no create privilege in a database? : Sql dba
Is left join same as inner join?
what is the difference between truncate and delete statement? : Transact sql
Cite the differences between execution of triggers and stored procedures?
Does truncate free space?
What is materialized view. What are different methods of refresh?
how to select first 5 records from a table? : Sql dba
how can we destroy the session, how can we unset the variable of a session? : Sql dba
Why do we use procedures in sql?
what is union? : Sql dba
Can primary key be changed?
What is dense_rank?
What are joins in sql?
How to order siblings in oracle hierarchy queries?
