The SQL Server provides various SQL Mathematical Functions, which allows us to perform basic math functionality such as the elementary exponential, square root, floor, round, logarithmic and trigonometric functions.

## SQL Mathematical Functions

The following table will show you the list of SQL Mathematical Functions in SQL Server

SQL Mathematical Functions | Description |
---|---|

ABS | It will return the Absolute value |

ACOS | It will return the trigonometric Arc Cosine value of a Given value |

ASIN | It will return the trigonometric Arc Sine value of a Given value |

ATAN | It will return the trigonometric Arc Tangent value of a Given value |

ATN2 | It is used to return the angle (in radius) from the X-Axis to the specified point (y, x) |

CEILING | It is used to return the smallest value which is greater than or equal to the specified expression or given value. |

COS | It is used to return the trigonometric Cosine value of a Given value |

COT | It is used to return the trigonometric Cotangent value of a Given value |

DEGREES | It is used to convert the specified radiant angle to equivalent angle measured in Degrees |

EXP | It is used to return E raised to the power of given value, Where E is Euler’s number and it is approximately equal to 2.71828. |

FLOOR | It is used to return the largest integer value which is less than or equal to the specified expression or a given value. |

LOG | It will calculate the natural logarithmic value of given number with base E, where E is Euler’s number, which is equal to 2.71828. |

LOG10 | It is used to calculate the base 10 logarithmic value of given number. |

PI | It will return the Pie Value, which is approximately equal to 3.14 |

POWER | It is used to return the power of user specified expression or value. |

RADIANS | It is used to convert the specified Degrees angle to equivalent angle measured in Radians |

RAND | It is used to return positive and the value will be greater than or equal to 0.0 and less than 1.0 |

ROUND | It is used to round the specified expression or an individual number to nearest numeric value. |

SIGN | It is used to return the Sign of the given argument, and the result may be Positive (+), Negative (-), or Zero (0). |

SIN | It is used to return the trigonometric Sine value of a Given value |

SQRT | It is used to find the square root of a specified expression or an individual number |

SQUARE | It is used to return the square of the specified expression or an individual number |

TAN | It is used to return the trigonometric Tangent value of a Given value |

From the above specified functions, all the Arithmetic functions such as: ABS, DEGREES, CEILING, FLOOR, POWER, SIGN, AND RADIANS return the result as same data type as the input value.

Trigonometric and other functions including: EXP, SQUARE, SQRT, LOG10, and LOG will CAST their input values to FLOAT data type, and return the result as FLOAT value.

People who want to save it as the Image:

Thank You for Visiting Our Blog