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
- 8243 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu sudhan g
Hiii
Its very simple to get the records that doesn't match lets
table1 is No1 and having A column values 1,2,3,4,5 and Table2
is No2 having column B values 1,2,3,4,5,6,7,8,9,10
Now Query is
select B from NO2 where B NOT IN(select A from NO1)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Where are full-text indexes stored?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is join and name different type of joins?
How to set a database state to offline in ms sql server?
What is bit data type? What's the information that can be stored inside a bit column?
What is difference in performance between insert top (n) into table and using top with insert?
What does this statement do @@rowcount?
What are four major operators that can be used to combine conditions on a where clause?
What are subquery and its properties?
What can be used instead of trigger?
What is a raid and what are different types of raid configurations?
How do database indexes work?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
What are the dmvs? : sql server database administration
Explain steps of normalization?
