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
- 8504 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 are the source of constraints?
How raid can influence database performance?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Where can you add custom error messages to sql server?
what is the difference between openrowset and openquery?
How to convert numeric expression data types using the cast() function?
What are wait types?
What is sql server query analyzer?
What are the different SQL Server Versions you have worked on?
How do I start sql server 2017?
Can we shrink data file in sql server?
Disadvantages of the indexes?
What is the primary use of the model database?
What is temporary table in sql server? Why we use temp table?
What is a coalesce function?
