Trusted answers to developer questions
Trusted Answers to Developer Questions

Related Tags

sql
communitycreator

What is ASIN() in SQL?

harris910

The ASIN() functionalso called the arc sine function returns the inverse sine of a number. To be more specific, it returns the inverse sine of a number in the radian float value.

Figure 1 shows the mathematical representation of the ASIN() function, and Figure 2 shows the visual representation of the ASIN() function.

Figure 1: Mathematical representation of inverse sine function
Figure 2: Visual representation of inverse sine function

Syntax

ASIN(number)

Parameter

This function requires a number as a parameter. The parameter must be a float value between -1 and 1, i.e., -1 <= parameter <= 1.

Return Value

ASIN() returns the inverse sine of a numberradian float value that is sent as a parameter. If the parameter is not between -1 and 1, it returns NULL.

Example

/*example showing how to use ASIN(X)*/

-- positive number
select ASIN(1);

-- negative number
select ASIN(-1);

-- fractional number
select ASIN(0.6);

-- not between -1 and 1
select ASIN(3);
select ASIN(-3);

RELATED TAGS

sql
communitycreator
RELATED COURSES

View all Courses

Keep Exploring