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
- 5193 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
How do I count rows in sql query?
Is primary key a clustered index?
What is the use of prepared statement?
Explain the difference between sql and mysql.
How do I view a table in sql?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Is pl sql different from sql?
What is the use of stored procedures?
Do stored procedures prevent sql injection?
What are some predefined exceptions in pl/sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
How can I see all tables in sql?
Why do we use cursors?
How can I get the number of records affected by a stored procedure?
what is bcp? When does it used? : Sql dba
