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
- 7397 Views
- I also Faced
- E-Mail Answers
Answer Posted / newbie
SELECT * from Table2
EXCEPT
SELECT * FROM Table1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between count () and rowcount ()?
What is best institute to Learn DotNET And SQL in chennai?
how you can list all the tables in a database?
What is policy based management (pbm)? : sql server database administration
How to use order by with union operators in ms sql server?
When would you use sql joins?
What are views in ms sql server?
What is mean by dml?
Can you name some of the dml commands in sql?
Explain about unique identifier data type in sql server?
how to trace the traffic hitting a sql server? : Sql server database administration
Where to find ntwdblib.dll version 2000.80.194.0?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How do you identify a foreign key?
Explain unique key in sql server?
