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
- 8381 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
How can I create a new template for import ? : sql server management studio
how you can move data or databases between servers and databases in sql server? : Sql server administration
How to convert a numeric expression from one data type to another?
Explain the commands in sql server?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
How would you use user_constraints table in DB?
How to get nth highest salary from employee table.
Difference between drill down and drill through report.
Explain sub-query?
Tell me about normalization in DBMS.
What is the command used to check locks in microsoft sql server?
What is the difference between row_number and dense_rank?
Mention the differences between local and global temporary tables.
Where sql server usernames and passwords are stored in a sql server?
How to integrate the ssrs reports in application?
