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
- 8491 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
What are the different subsets of sql?
What is temporary table in sql server? Why we use temp table?
How to connect php with different port numbers?
What is the primary use of the model database?
What is a view in sql?
How do I find the sql server version?
How do I find query history in sql server?
Can one drop a column from a table?
How do I create a trace in sql server?
What are the different SQL Server Versions you have worked on?
Explain “row_number()” in sql server with an example?
What is standby servers? Explain types of standby servers.
what is the Ticketing tool used in Wipro technologies at Bangalore...???
List the ways in which dynamic sql can be executed?
What is subquery? Explain the properties of a subquery?
