I have try the command Column_name != Value in where clause, but teradata alerts error [3707: 42000] expected something like an 'IN' keyword or a 'CONTAINS' keyword between the word 'RETAIL_PRICE' and '|'.
I have check the Basic Teradata Query Reference, it does show condittion != as not equal to. but why it alerts error? Actually it works if I change != to NE.
Can anyone helps? Thank you!
can we use Not IN if we want to see a row whci is not present in other table Ex;- Examine some of the rows in the trnsact table that are not in the skstinfo table?