SQL ASIN() Function Example | ASIN() in SQL

SQL ASIN() is an inbuilt function that is used for finding the arc sine of a number. The number should be in the range of -1 to 1; otherwise, it will return NULL.

SQL ASIN()

SQL ASIN() function returns the arc sine of a number. The specified number must be between -1 to 1; otherwise, this function returns NULL.

Syntax

SELECT ASIN(Expression);

Parameters

Expression: The Expression whose cosine value is to be retrieved.

Examples

Query 1

SELECT ASIN (1);

Output

1.5707963267949

Explanation

Here, arc sine value is returned.

Query 2

SELECT ASIN (-0.8);

Output

-0.9272952180016123

Explanation

Here, the arcsine value is returned.

Query 3

SELECT ASIN (NULL);

Output

NULL

Explanation

Passing of NULL value as an argument will return a NULL value.

Query 4

SELECT ASIN(0.25);

Output

0.25268025514207865

Explanation

Here, arcsine value is returned, which is of fractional type.

Query 5

SELECT ASIN (0.1 + 0.3);

Output

0.411516846067488

Explanation

Here, the arcsine value of the expressions is returned.

Conclusion

SQL Server ASIN() function returns the arcsine of a number.

See also

SQL ACOS()

SQL ABS()

SQL SIN()

SQL SQRT()

SQL SIGN()