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
- 8244 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
What is the command to change the recovery model?
List all the types of user-defined functions?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Can group functions be used in the order by clause in ms sql server?
How can I get data from a database on another server?
What are data regions?
What is postgresql server?
why would you call update statistics? : Sql server database administration
What the class forname () does?
How to rebuild all indexes on a single table?
What is the use of toad or sqldbx.?
Explain how to send email from sql database?
What does it mean to normalize data?
Can another user execute your local temporary stored procedures?
Explain what role entity and relationship play in an ER diagram.
