Mathematical Functions

Team-Fly    

 
Sams Teach Yourself SQL in 24 Hours, Third Edition
By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 11.  Restructuring the Appearance of Data


Mathematical functions are fairly standard across implementations . These are functions that allow you to manipulate numeric values in a database according to mathematical rules.

The most common functions include the following:

Absolute value

(ABS)

Rounding

(ROUND)

Square root

(SQRT)

Sign values

(SIGN)

Power

(POWER)

Ceiling and floor values

(CEIL, FLOOR)

Exponential values

(EXP)

SIN, COS, TAN

 

The general syntax of most mathematical functions is

 graphics/syntax_icon.gif FUNCTION(EXPRESSION) 

Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net