December 19th, 2008
SQRT (square root of no.)
Posted by
admin in
H. ANSI Numeric Scalar Functions
he SQRT function returns the square root of a number.
Format: SQRT(expression)
Example: SQRT(100) Result: 10
SQRT(10000) Result: 100
Â
> DB2, MySQL, Oracle, PostgreSQL, and SQL Server support the POWER function.
> Access uses ^ (an up arrow) to raise a number to a power or exponent.
> Where 10 ^ 2 = 100, you can use 100 ^ (1/2) = 10 (the square root).
Alternatively, you could use 100 ^ .5 = 10.
1000 ^ (1/3) = 10 (the cube root).
Â
Â
