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
- 8383 Views
- I also Faced
- E-Mail Answers
Answer Posted / gangadhar
select * from table2 where id not in ( select id from
table1)
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
How to insert multiple rows with one insert statement in ms sql server?
How to use wildcard characters in like operations in ms sql server?
Introduction of rollup clause using sum and group by clause?
Do you know what is sql service broker?
How to drop existing views from a database in ms sql server?
How do I schedule a sql server profiler trace?
What do you mean by data manipulation language?
What is subquery in sql?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
what is normalization? Explain different levels of normalization? : Sql server database administration
What does COMMIT command do?
What are the recovery models in sql server 2000?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is entity data services?
