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
- 4091 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 is union?
what does the t-sql command ident_current does? : Transact sql
How to return multiple rows from the stored procedure?
how can we know the number of days between two given dates using mysql? : Sql dba
What are types of joins?
What is the use of sql trace?
Why do we use set serveroutput on?
What are operators available in sql?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is a table in a database?
What is oracle pl sql developer?
What is auto increment?
Does mysql support pl sql?
Explain what is sql?
How can I speed up sql query?
