Friday 2 November 2012

Mod operator in Teradata - How modulus works?

Modulus operator or the Mod operator gives us the remainder post-division.

Teradata has the MOD function that has the same functionality.

Example

               7 divided by 2 
               Quotient is 3
               Remainder is 1

So 7 MOD 2 gives 1

We have the same function in Teradata.

The syntax is:

SELECT 7 MOD 2;

This is a sample question for the Teradata certification exams




No comments:

Post a Comment

Please share your thoughts and let us know the topics you want covered