SQL Mathematical Functions

• SQL CEIL() (or CEILING) and FLOOR() Functions

  Both SQL CEIL(or CEILING) and FLOOR functions are round the numbers. SQL CEIL roundup to the nearest integer value while FLOOR round down to the next least integer value.

• SQL RAND Function

  The SQL RAND() function is used to generate some random numbers at run time.

• SQL ABS Function

  SQL ABS function returns the absolute value of an numeric input argument.

• SQL EXP Function

  The SQL EXP() function returns e raised to the n-th power (e is the base of the natural logarithm and is equal to approximately 2.718281828459).

• SQL PI Function

  SQL PI() function maybe the most simplest mathematical SQL function because it returns a constant value of pi

• SQL SQRT Function

  The SQL SQRT function extracts the square root from the positive numeric input argument. SQL SQRT function accepts only positive arguments, and returns an error when a negative argument is passed in.

• SQL POWER Function

  The SQL POWER() function returns the

• SQL ROUND Function

  The SQL ROUND function rounds a number to a specific length or precision.

• SQL LOG Function

  The SQL LOG() function allows us to operate mathematical logarithmic calculation

• SQL Trigonometric Functions

  SQL trigonometric functions allow you to operates trigonometric calculations.Here are some common SQL trigonometric functions you need to know in your daily SQL programming.

• « Previous page
• Next page »