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
- 7400 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
How to select an exiting database using mssql_select_db()?
What is clr ddl trigger?
What is the datatype of rowid?
Mention the 3 ways to get a count of the number of records in a table.
What is the use of RDBMS?
How each E-R model constructs can be mapped to the relational model?
can an automatic recovery be initiated by a user? : Sql server administration
How many types of cursor type are there?
what is a mixed extent? : Sql server administration
Difference between DELETE and TRUNCATE?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to create a simple user defined function in ms sql server?
Do you know what is user defined datatypes and when you should go for them?
What is purpose of normalization?
