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
- 8235 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
Is it possible in sql table to have more than one foreign key?
How network traffic be reduced by using the stored procedure?
Write a SQL queries on Self Join and Inner Join.
When is update_statistics command used?
How will you decide the active and passive nodes?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
You want to implement the one-to-many relationship while designing tables. How would you do it?
What is difference between clustered index and non clustered index?
What are synonyms?
What is the syntax for encrypting a column in SQL Server?
How many types of attribute relationships are there? : sql server analysis services, ssas
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What does the not null constraint do?
Write down the syntax and an example for create, rename and delete index?
Can you name some of the dml commands in sql?
