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
- 6389 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
What stored by the master? : sql server database administration
What is NOT NULL Constraint in sql server 2012?
How do I start and stop sql server?
What is difference between foreign key and unique key?
Differentiate between a primary key and a unique key.
What is 1nf 2nf and 3nf?
What is named calculation? : sql server analysis services, ssas
Where the sql logs gets stored? : sql server database administration
Explain magic tables in sql server?
what are the three command line utilities and what are their primary functions?
What happens if we shrink log file in sql server?
How to find related tables in sql server?
What is SubQuery in SQL Server 2008
what is nonclustered index
Which tcp/ip port does sql server run on? How can it be changed?
