O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 34

Math Functions

“Ideas pull the trigger, but instinct loads the gun.”

–Don Maquis

Table of Contents Chapter 34 – Math Functions

What is the Order of Precedents?

What is the Answer to this Math Question?

What is the Answer to this Math Question?

What is the Answer to this Math Question?

What is the Order of Precedents?

Order of Precedents for Math

( ) Parenthesis  ** Exponentiation   * Multiplication  /  Division  +  Addition  -  Subtraction

Mathematics can be used within your Syntax. But, like any math problems, it has an Order of Precedents.

What is the Answer to this Math Question?

SELECT (2 + 4) * 5

What is the Answer?

30

This is an example of mathematics taking place with the Order of Precedents being respected.

What ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required