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
- 8174 Views
- I also Faced
- E-Mail Answers
Answer Posted / newbie
SELECT * from Table2
EXCEPT
SELECT * FROM Table1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I find the port number for sql server?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What is order of B+tree?
What is best institute to Learn DotNET And SQL in chennai?
Why are you getting errors when creating a new odbc dsn?
What is attribute? : sql server analysis services, ssas
What are the 2 types of classifications of constraints in the sql server?
Explain some stored procedure creating best practices or guidelines?
What is the use of RDBMS?
What are the restrictions while creating batches in sql server?
How to remove duplicate rows from table except one?
What is the impact on other user sessions when creating indexes?
What are relationships and mention different types of relationships in the dbms
What is indexing explain it with an example?
What is the use of stored procedure?
