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
- 8053 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
Why I am getting this error when dropping a database in ms sql server?
What is the difference between nvl and nvl2?
How to identify current user in ssrs report?
What is the difference between index seek vs. Index scan?
What are the advantages of using a stored procedure?
What are the advantages of policy management?
which backup strategy you are following at ur company
How you can get the list of largest tables in a database?
What is schemabinding a view?
How to create a user to access a database in ms sql server using "create user" statements?
your distribution database is full what will u do
What is always encrypted?
Why is sql server log file full?
What sql server means?
What does indexation mean?
