I am Having tables T1 and T2 both having same data how to
check (or) compare the data in both table are same?
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
how many clustered indexes can be created on a table? : Sql server database administration
What do you mean by data manipulation language?
Define Business Edition in SQL Azure?
What does it mean to manipulate data?
Does table partitioning improve performance?
Will count(column) include columns with null values in its count?
What is the use of nvl work?
Do you know what are the differences between lost updates and uncommitted dependencies?
Explain user defined functions?
How to skip remaining statements in a loop block using continue statements?
 Explain what is sql override for a source taLle in a mapping?
What are the restraints imposed on the table design by a merge replication?
What does Master database contains?
What are .mdf files?
What are the dis_advantages of stored procedures, triggers, indexes?