Interested to Buy Any Domain ? << Click Here >> for more details...
I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
- 3 Answers
- 6152 Views
- I also Faced
- E-Mail Answers
Answer Posted / thakur singh rawat
(select * from T1
minus
select * from T2)
union
(select * from T2
minus
select * from T1)
If no rows returns then it means that the two tables
contain the same values or say same.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
In which format does an image save in SQL Server database ?
What are the characteristics of modern DBMS?
What is the difference between sdf and mdf?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What are the approximate numeric data types?
Describe how to use linked server?
How can you insert null values in a column while inserting the data?
how many clustered indexes can be created on a table? : Sql server database administration
How to delete an existing row with delete statements in ms sql server?
What have included columns when we talk about sql server indexing?
What is sql azure database?
What is a transactions?
How to insert new line characters into strings?
How does a profiler work?
Do you know query execution plan?
