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

CONTRIBUTOR

harris910
RELATED COURSES

View all Courses

Keep Exploring

Learn in-demand tech skills in half the time 