SQL has many mathematical functions that allow you to perform business and engineering calculations.<\/p>\n\n\n\n
Not all of the SQL math functions are used in typical day-to-day operations. However, there are several commonly used functions illustrated in the following table:<\/p>\n\n\n\n
<\/p>\n\n\n\n SQL has many mathematical functions that allow you to perform business and engineering calculations.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":65,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1083","page","type-page","status-publish","hentry"],"yoast_head":"\nName<\/strong><\/th> Description<\/strong><\/th><\/tr><\/thead> ABS<\/a><\/td> Returns the absolute value<\/td><\/tr> ACOS<\/a><\/td> Returns the arc cosine of an argument<\/td><\/tr> ASIN<\/a><\/td> Returns the arc sine of an argument<\/td><\/tr> ATAN<\/a><\/td> Returns the arc tangent of an argument<\/td><\/tr> CEIL<\/a>,CEILING<\/a><\/td> Rounds up a float to the nearest integer value<\/td><\/tr> COS<\/a><\/td> Returns the cosine of an argument<\/td><\/tr> COT<\/a><\/td> Returns the cotangent of an argument<\/td><\/tr> EXP<\/a><\/td> Returns the e<\/code> constant (2.71828\u2026) that raises to a power of a specified number<\/td><\/tr>LN<\/td> Returns the natural logarithm of the argument<\/td><\/tr> LOG<\/td> Returns the natural logarithm of the first argument<\/td><\/tr> LOG10<\/td> Returns the base-10 logarithm of the argument<\/td><\/tr> LOG2<\/td> Returns the base-2 logarithm of the argument<\/td><\/tr> MOD<\/a><\/td> Returns the remainder (modulo) of a number divided by another<\/td><\/tr> PI<\/td> Returns the value of pi which is 3.14159265358979<\/td><\/tr> POWER<\/a><\/td> Returns a number raised to a power of a specified number<\/td><\/tr> RAND<\/a><\/td> Returns a random floating-point value<\/td><\/tr> ROUND<\/a><\/td> Rounds a number to a specific precision<\/td><\/tr> SIGN<\/td> Returns the sign of an argument<\/td><\/tr> SIN<\/a><\/td> Returns the sine of an argument<\/td><\/tr> SQRT<\/a><\/td> Returns the square root of an argument<\/td><\/tr> TAN<\/a><\/td> Returns the tangent of an argument<\/td><\/tr> TRUNCATE<\/a><\/td> Truncates to a specified number of decimal places<\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"