{"id":3680,"date":"2024-04-03T16:52:15","date_gmt":"2024-04-03T09:52:15","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/?page_id=3680"},"modified":"2024-04-08T09:03:28","modified_gmt":"2024-04-08T02:03:28","slug":"sql-server-math-functions","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-math-functions\/","title":{"rendered":"SQL Server Math Functions"},"content":{"rendered":"\n

This SQL Server math functions page offers a comprehensive collection of mathematical functions. These math functions empower your SQL queries with advanced computational capabilities. <\/p>\n\n\n\n

If you’re manipulating numerical data, performing complex calculations, or analyzing trends, SQL Server offers an array of functions to meet your mathematical needs.<\/p>\n\n\n\n

Function<\/th>Description<\/th><\/tr><\/thead>
ABS<\/a><\/td>Return the absolute value of a number.<\/td><\/tr>
ACOS<\/a><\/td>Return an angle (in radians) of a specified cosine.<\/td><\/tr>
ASIN<\/a><\/td>Return an angle (in radians) of a specified sine.<\/td><\/tr>
ATAN<\/a><\/td>Return the arctangent (in radians) of a specified tangent.<\/td><\/tr>
CEILING<\/a><\/td>Round a number to the nearest integer greater than or equal to the input number.<\/td><\/tr>
COS<\/a><\/td>Return the cosine of the specified angle, measured in radians.<\/td><\/tr>
COT<\/a><\/td>Return the cotangent of the specified angle, which is the reciprocal of the tangent.<\/td><\/tr>
DEGREES<\/a><\/td>Convert an angle value in radians to degrees.<\/td><\/tr>
EXP<\/a><\/td>Return the exponential value of a number.<\/td><\/tr>
FLOOR<\/a><\/td>Round a number to the nearest integer less than or equal to the input value.<\/td><\/tr>
LOG<\/a><\/td>Return the natural logarithm of a float with a specific base (default to e).<\/td><\/tr>
PI<\/a><\/td>Return the constant value of PI, accurate to 15 digits.<\/td><\/tr>
POWER<\/a><\/td>Return the result of raising a number to a specific power.<\/td><\/tr>
RAND<\/a><\/td>Return a random float between 0 and 1.<\/td><\/tr>
RADIANS<\/a><\/td>Convert an angle value in degrees to radians.<\/td><\/tr>
ROUND<\/a><\/td>Return a number rounded to a specified precision.<\/td><\/tr>
SIGN<\/a><\/td>Return the sign of a number, 1 for positive, -1 for negative, and 0 for zero.<\/td><\/tr>
SIN<\/a><\/td>Return the sine of an angle in radians.<\/td><\/tr>
SQRT<\/a><\/td>Return the square root of a float.<\/td><\/tr>
SQUARE<\/a><\/td>Return the square of a number.<\/td><\/tr>
TAN<\/a><\/td>Return the tangent of the specified angle, measured in radians.<\/td><\/tr><\/tbody><\/table><\/figure>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
\n\t\t
\n\t\t\t
<\/div>\n\t\t\t\n\t\t\t