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
- 8166 Views
- I also Faced
- E-Mail Answers
Answer Posted / debi
(select * from table2)
minus
(select * from table1)
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
What’s the use of custom fields in report?
What are the advantages of using third-party tools?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What are the types of sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What are different types of subquery?
Tell me when is the update_statistics command used?
What is the difference between osql and query analyzer?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
Can we use where clause in union?
Which command is used for user defined error messages?
How to enter binary string literals in ms sql server?
Explain the difference between clustered and non-clustered index?
What is update locks?
