Collections:
SQRT() - Square Root of X
How to calculate the square root of a given number using the SQRT() function?
✍: FYIcenter.com
SQRT(X) is a MySQL built-in function that calculates the square root of a given number. For example:
SELECT SQRT(2), SQRT(4), SQRT(8); -- +--------------------+---------+--------------------+ -- | SQRT(2) | SQRT(4) | SQRT(8) | -- +--------------------+---------+--------------------+ -- | 1.4142135623730951 | 2 | 2.8284271247461903 | -- +--------------------+---------+--------------------+
Reference information of the SQRT() function:
SQRT(X): val Returns the square root of a nonnegative number X. Arguments, return value and availability: X: Required. The input number. val: Return value. The square root of X. Available since MySQL 4.0.
⇒ TAN() - Tangent Trigonometric Value
⇐ SIN() - Sine Trigonometric Value
2023-11-14, 320🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...