Interested to Buy Any Domain ? << Click Here >> for more details...
hi,
how to match retrieve the unmatched records from 2 tables
in which we dont have any primary key. example : table1 has
1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want
the numbers from 6 to 10 to be displayed and should not
come as null. i need the numbers. please reply as soon as
possible.
- 4 Answers
- 8234 Views
- I also Faced
- E-Mail Answers
Answer Posted / debi
(select * from table2)
minus
(select * from table1)
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What is an execution plan? How would you view the execution plan?
According to you what goes into making the best database administrator? : sql server database administration
Please explain what is “asynchronous” communication in sql server service broker?
What is de-normalization and what are some of the examples of it?
How to delete multiple rows with one delete statement in ms sql server?
How to check if a table is being used in sql server?
Does union all remove duplicates?
What is the difference between primary key and unique constraints?
How many types of keys are there?
What is self join in sql server joins?
What is cached report?
What is the use of keyword with encryption. Create a store procedure with encryption?
How many primary keys are possible in a table?
Determine when an index is appropriate?
What is the use of sign function?
