difference between minus and except in Teradata

Question

what is the difference between minus and except in teradata?

score 5 · Accepted Answer · answered Jan 05 '11 at 18:20

5

They are equivalent, the difference being that except is ANSI compliant.

answered Jan 05 '11 at 18:20

Joe Stefanelli

Hi I am new in Teradata so couldn't understand what does ANSI compliant means...could you please brief me on this? – Vivart Jan 05 '11 at 18:33
1

ANSI compliant means the syntax conforms to the ANSI standard for SQL. See [here](http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt). – Joe Stefanelli Jan 05 '11 at 18:41
It is advisable to leverage ANSI compliant SQL whenever possible. This avoids the potential for problem when Teradata specific features are deprecated as ANSI compliant replacements are introduced. (e.g. Window Aggregation vs OLAP functions such as MSUM()) – Rob Paller Feb 03 '11 at 03:32

score 1 · Answer 2 · answered Jan 05 '11 at 18:36

1

Here is a good link for you:

answered Jan 05 '11 at 18:36

Naveed

2 Answers2