Page 17 of 23PREVNEXT

Queries II: Limit your data and calculate values

 
Operator Purpose
+ Addition.
- Subtraction.
* Multiplication.
/ Division.
\ Division in which both numeric expressions and the quotient are rounded.
^ Raises the first numeric expression by the power in the second.
Mod Rounds both numeric expressions to integers, divides the first integer by the second, and returns only the remainder. Helpful for returning every nth record, such as every seventh record.
Operators and their precedence.

Expressions use arithmetic operators. As you recall from the first lesson, operators are symbols or words that perform actions on your data.

Some arithmetic operators can also be used to combine (or concatenate) text fields, but in this course you'll learn about using operators with values.

You'll probably use the operators for addition (+), subtraction (-), multiplication (*), and division (/) most often, but it's helpful to know about the other operators and their purpose.

Page 17 of 23PREVNEXT