DBAs who comes with Oracle background would look for MINUS clause in order to compare the results of the SQL statements that return same type of result sets.
In Oracle, we use
select * from tab1
minus
select * from tab2;
But, in SQLserver, we have to use EXCEPT clause
select * from tab1
except
select * from tab2;
In Oracle, we use
select * from tab1
minus
select * from tab2;
But, in SQLserver, we have to use EXCEPT clause
select * from tab1
except
select * from tab2;
No comments:
Post a Comment