Skip to content
Related Articles

Related Articles

Improve Article

ASIN() and ACOS() Function in MySQL

  • Last Updated : 30 Sep, 2020

1. ASIN() Function :
ASIN() function in MySQL is used to return  the arc sine of any number in the range[ -1, 1] . It Returns NULL if the number is not in the range -1 to 1.

Syntax :

ASIN(X)

Parameter :
ASIN() function accepts one parameter as mentioned above and described below.

  • X –A number whose arc sine we want to calculate .It should be in the range [-1, 1].

Returns :
It returns the arc sine of given number x.

Example-1 :
Arc sine of  1  using ASIN() function.



SELECT ASIN(1) AS Asin_Val ;

Output :

Asin_Val
1.5707963267948966

Example-2 :
Arc sine of  a number in the range(0, 1)  using ASIN() function.

SELECT ASIN(0.25) AS Asin_Val;

Output :

Asin_Val
0.25268025514207865

Example-3 :
Arc sine of  a number in the range(0, -1)  using ASIN() function.

SELECT ASIN(-0.35) AS Asin_Val;

Output :

Asin_Val
-0.35757110364551026

Example-4 :
Arc sine of  a number which is not in the range[0, -1] using ASIN() function.

SELECT ASIN(2.75) AS Asin_Val ;

Output :

Asin_Val 
NULL

Example-5 :
Arc sine value of a numeric column in a table.



Table -Number

X
-2
-1
-0.50
0
0.50
1
2
SELECT X, ASIN(X) AS ArcSin_X  FROM Number ;

Output :

XArcSin_X
-5NULL
-1-1.5707963267948966
-0.50-0.5235987755982989
00
0.500.5235987755982989
11.5707963267948966
2NULL

2. ACOS() function :
ACOS() function in MySQL is used to return the arc cosine of any number in the range[ -1, 1].It Returns NULL if the number is not in the range -1 to 1.

Syntax :

ACOS(X)

Parameter :
ACOS(X) function accepts one parameter and In ACOS(X) function X is the parameter. Let’s understand with the help of examples.

  • X –A number whose arc cosine we want to calculate .It should be in the range [-1, 1].

Returns :
It returns the arc cosine of given number x.

Example-1 :
Arc cosine of  1  using ACOS() function.

SELECT ACOS(1) AS Acos_Val;

Output :

Acos_Val
0

Example-2 :
Arc cosine of a number in the range(0, 1) using ACOS() function.

SELECT ACOS(0.75) AS Acos_Val;

Output :



Acos_Val
0.7227342478134157

Example-3 :
Arc cosine of  a number in the range(0, -1) using ACOS() function.

SELECT ACOS(-0.75) AS Acos_Val ;

Output :

Acos_Val
2.4188584057763776

Example-4 :
Arc cosine of  a number which is not in the range[0, -1] using ACOS() function.

SELECT ACOS(2.75) AS Acos_Val;

Output :

Acos_Val
NULL

Example-5 :
Arc cosine value of a numeric column in a table.

Table -Number

X
-5
-1
-0.50
0
0.50
1
2
SELECT X, ACOS(X) AS Acos_Val  FROM Number;

Output :

XAcos_Val
-5NULL
-13.141592653589793
-0.502.0943951023931957
01.5707963267948966
0.501.0471975511965979
10
2NULL

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up
Recommended Articles
Page :