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.
Answer Posted / rizaul
I have used inner joins
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is blind sql injection?
how to present a past time in hours, minutes and seconds? : Sql dba
How to process query result in pl/sql?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is sql injection vulnerability?
List the different type of joins?
How many types of literals are available in pl sql?
What are the types of keys?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is difference between pls_integer and integer?
Does sql require a server?
What is difference between function and trigger?
Which operator is used in query for pattern matching?
Define sql delete statement.