MySQL POW() Function17 Mar 2025 | 1 min read The pow() is a Math function of MySQL. This function is used to get the power of the given values. SyntaxParameter:m: It is base value in the calculation n: It is exponent value in the calculation ReturnsThis function returns m raised to the nth power. Example 1Output:  Example 2Output:  Next TopicMySQL Math |
MySQL ROUND() Function The round() is a Math function of MySQL. This function is used to round off the given number. Syntax select round(number); Parameter: number: value to be round off. Returns This function returns a number rounded to a certain number of decimal places. Example 1 Select round(164.325); Output: Example 2 Select round(46.225); Output: TopicMySQL Math ...
1 min read
MySQL FLOOR() Function The floor() is a Math function of MySQL. This function is used to find the greatest integer which is equal to or less than the given number. Syntax select floor(number); Parameter Number : It is the number to find the greatest integer. Returns This function returns the largest integer value...
1 min read
MySQL ATAN() Function The atan() is a Math function of MySQL. This function is used to get the arc tangent of the given number. Syntax select atan(num); Parameters: Num: It is the number to get arc tangent. Returns This function returns the arc tangent of the given number. Example 1 Select atan(0.45); Output: Example 2 Select atan(0.4,...
1 min read
MySQL ASIN() Function The asin() is a Math function of MySQL. This function is used to get the arc sine of the given number. Syntax select asin(num); Parameters: Num: It is the number to get arc asin. Returns: This function returns the arc sine of a number. Example 1 Select asin(3454); Output: Example 2 Select asin(0.3454); Output: Example 3 Select asin(0.34); Output: ...
1 min read
MySQL COUNT() Function The count() is a Math function of MySQL. This function is used to get the total count for a particular column of the table. Syntax select count(column_name) from table_name Parameter column_name: It is the column name to get the count. table_name: It is the name of the table in...
1 min read
MySQL CEIL() Function The ceil() is a Math function of MySQL. This function returns the smallest value which is greater than or equal to the given number. Syntax select ceil(num); Parameter: Num: number for getting ceil value Returns This function returns the smallest integer value that is greater than or equal to a...
1 min read
MYSQL Math functions MySQL provides a wide range of functions which serves a wide range of arithmetical purposes. The following table indicates each of the functions with a brief description: Functions Description ABS() The ABS() function returns the absolute value of the specified number. ACOS() The ACOS() function is used to get...
3 min read
MySQL RADIANS() Function The radians() is a Math function of MySQL. This function is used to convert the given degrees to radians. Syntax select radians(number); Parameter: number: It is the number to be converted into radian Example 1 select radian(23); Output: Example 2 select radian(45.1); Output: TopicMySQL Math ...
1 min read
MySQL ABS() Function The abs() is a Math function of MySQL. This function is used to get the absolute value of the given number. Syntax select abs(num); Parameters: num: It is the number to get absolute value. Returns This function returns the absolute value of a number. Example 1 Select abs(11); Output: Example 2 Select abs(11.2); Output: Example 3 Select abs(-11.2); Output: Example...
1 min read
MySQL EXP() Function The exp() is a Math function of MySQL. This function is used to find e raised to the power of number i.e. enumber. Syntax select exp(number); Parameter Number : It is the number to be raised in e. Returns This function returns e raised to the power of a number. Example...
1 min read
We request you to subscribe our newsletter for upcoming updates.
We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks
G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India
Python
Java
JavaScript
SQL
C
C++
HTML
CSS
React
Node.js
Spring Boot
C#
PHP
MySQL
MongoDB
AI
ML
DSA
DBMS
OS
Aptitude
Reasoning