MySQL AVG() Function17 Mar 2025 | 1 min read The avg() is a Math function of MySQL. This function is used to get the average value from the given expression. SyntaxParameteraggregate_expression: It is the column name for getting average table_name: It is the table for getting records. where condition: It is optional. It is used to get conditional records. ReturnsThis function returns the average value from the given expression. Table: Example 1Output:  Example 2Output:  Example 3Output:  Next TopicMySQL Math |
MySQL LOG2() Function The log2() is a Math function of MySQL. This function is used to get the base-2 logarithm of given number. Syntax select log2(number) Parameter: number: It is the number for base-2 logarithm value. Returns: This function returns the base-2 logarithm of a number. If the number is less than or...
1 min read
MySQL ATAN2() Function The atan2() is a Math function of MySQL. This function is used to get the arc tangent of the given number n and m. Syntax select atan(n, m); Parameters: N, m: two numbers to get arc tangent. Returns This function returns the arc tangent of the given number n...
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
MySQL COT() Function The cot() is a Math function of MySQL. This function is used to get the cotangent of the given number. Syntax select cot(num); Parameters: Num: It is the number to get cotangent value. Returns This function returns the cotangent of the given number. Example 1 Select cot(10); Output: Example 2 Select cot(5.2); Output: Example 3 Select cot(-6); Output: TopicMySQL...
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 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 MIN() Function The min() is a Math function of MySQL. This function is used to get the minimum number of the given column name. Syntax select min(aggregate_expression) from table_name; Parameter: aggregate_expression: column name from the table table_name: name of the table. Example 1 TopicMySQL Math ...
1 min read
MySQL PI() Function The pi() is a Math function of MySQL. This function is used to get the value of pi upto 6 decimal places. Syntax select pi(); Returns This function returns the value of ? (pi) displayed with 6 decimal places. Example 1 select pi(); Output: Example 2 select pi()+12; 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 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
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