The SQUARE() function finds the square of a given number. For example, if a number passed in the function is 5, it will return 25.
Note: This function accepts both negative and positive numbers. Moreover, the function also accepts fractions. The function will always return a positive value.
SQUARE(number)
number: This is the number whose square will be returned.
This example takes a positive number in the function. The function returns the number’s square.
SELECT SQUARE(10);
100.0
This example takes a negative number in the function. The function returns the number’s square.
SELECT SQUARE(-3);
9.0