login

SQL Mathematical Functions

Sponsored Links
  • 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.
Sponsored Links