SELECT ACOS( X )
The output is arc cos of X or the value for which COS() is X
This function only takes input in range of -1 to 1, for any other input the output will be NULL.
Let us start with some known output of Sin.
SELECT ACOS(0);// Output 1.5707963267948966
SELECT ACOS(1); // Output is 0
SELECT ACOS(-2); // Output is NULL
Using ROUND() with ACOS()
SELECT ROUND(ACOS(0),2);// Output is 1.57
We are getting outputs in radian, so to change the value to degree we will use DEGREES()
ACOS() with DEGREES()
SELECT DEGREES(ACOS(0)); // Output is 90
SELECT DEGREES(ACOS(0)); // Output is 90
SELECT DEGREES(ACOS(-1)); // Output is 180
SIN() function
SQL Video Tutorials