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.
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
Do you know what are the restrictions that views have to follow?
What is right outer join in sql server joins?
what exactly sql injuction.how to overcome.....
what is the difference between delete table and truncate table commands? : Sql server database administration
Who is the owner of a schema in ms sql server?
Explain the different types of joins?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Please illustrate physical database architecture? : SQL Server Architecture
What is the difference between stored procedure and user defined functions?
When would you use sql joins?
What is public role in sql server?
What is the purpose of optimization?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Explain about Normalization?
What is difference between Datepart() and Datename() in SqlServer?