search

Accenture / DBTestCompare

Application to compare results of two SQL queries
MIT License
25 stars 12 forks source link

Use MINUS ALL in Teradata to get full result set #20

Closed maciejrudy-zz closed 7 years ago

maciejrudy-zz commented 7 years ago

Use MINUS ALL in Teradata, instead of just MINUS:

query1 MINUS ALL query2 UNION ALL query2 MINUS ALL query1

Not for all databases, as e.g. Microsoft SQL Server does not support the ALL clause.