MySQL MOD() Function17 Mar 2025 | 1 min read The mod() is a Math function of MySQL. This function is used to get the remainder of given values. SyntaxParameter:n: number to be divided by m m: number that will divide n ReturnsThis function returns the remainder of n divided by m. Example 1Output:  Example 2Output:  Example 3Output:  Next TopicMySQL Math |
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 SUM() Function The sum() is a Math function of MySQL. This function is used to sum the values of given expressions. Syntax select sum(aggregate_expression) from tables [where conditions]; Parameter: aggregate_expression: It is the column to be summed. tables: It is the name of the table in which given aggregate_expression is present. where...
1 min read
MySQL SQRT() Function The sqrt() is a Math function of MySQL. This function is used to get the square root of the given number. Syntax select sqrt(number); Parameter: number: It is the number for getting sqrt. Example 1 Select sqrt(02); Output: Example 2 Select sqrt(-2); Output: Example 3 Select sqrt(32); Output: TopicMySQL Math ...
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 MAX() Function The max() is a Math function of MySQL. This function is used to get the maximum number of the given column name. Syntax select max(aggregate_expression) from table_name; Parameter: aggregate_expression: column name from the table table_name: name of the table. Returns This function returns the maximum value of an expression. Example 1 TopicMySQL...
1 min read
MySQL COS() Function The cos() is a Math function of MySQL. This function is used to get the cosine of the given number. Syntax select cos(num); Parameters: Num: It is the number to get cosine value. Returns This function returns the cosine of the given number. Example 1 select cos(11); Output: Example 2 select cos(1.12); Output: Example 3 select cos(-2); Output: TopicMySQL...
1 min read
MySQL ACOS() Function The acos() is a Math function of MySQL. This function is used to get the arc cosine of the given number. Syntax select acos(num); Parameters: num: It is the number to get the arc cosine. Returns This function returns the arc cosine of a number. Example 1 Select acos(0.23654); Output: Example 2 Select acos(23654); Output: Example 3 Select...
1 min read
MySQL DIV() Function The div() is a Math function of MySQL. This function is used for integer division, in which n is the number to be divided by the number m. Syntax select n div m; Parameter n : It is the number to be divided by m m : It is...
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 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