MySQL SIN() Function17 Mar 2025 | 1 min read The sin() is a Math function of MySQL. This function is used to get the sine value of the given number. SyntaxParameter:number: It is the number for getting sine. Return:This function returns the sine value of the given number. Example 1Output:  Example 2Output:  Next TopicMySQL Math |
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 LN() Function The LN() is a Math function of MySQL. This function is used to get the natural logarithm of the given number. Syntax select LN(number); Prameter: number : It is the number for getting log value. Returns This function returns the natural logarithm of the given number. If the number is...
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 SIGN() Function The sign() is a Math function of MySQL. This function is used to get a sign of the given number. If the number is less than 0, this function returns -1. If the number is 0 or 1 or greater than 0, this function...
1 min read
MySQL LEAST() Function The least() is a Math function of MySQL. This function is used to get the smallest number from the list. Syntax select least(exp1, exp2, exp3.....); Prameter: Exp1, exp2, exp3.... expn : expressions for getting smallest number. Returns This function returns the smallest number from the list. Example 1 Select least(4,3,2,7); Output: Example 2 Select least(javatpoint','string_finction','math_function','date_function'); Output: Example...
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 LOG10() Function The Log10() is a Math function of MySQL. This function is used to get the base-10 logarithm of given number. Syntax select log10(number); Prameter: number: It is the number for getting the log value. Returns This function returns the base-10 logarithm of a number. If the number is less than...
1 min read
MySQL POWER() Function The power() is a Math function of MySQL. This function is used to get the power of the given values. Syntax select power(m,n); Parameter: m: It is base value in the calculation n: It is exponent value in the calculation Returns This function returns m raised to the nth power. Example 1 Select...
1 min read
MySQL TRUNCATE Function The truncate() is a Math function of MySQL. This function is used to get the given number truncated up to given certain decimal places. Syntax select truncate(number, decimal_places); Parameter: Number: It is the number to truncate. decimal_places: It is the number of decimal places truncate to. Returns This function returns the...
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
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