ASIN()

The ASIN() function in SQL is a mathematical function that returns the inverse sine or arcsine of a number.

Syntax

ASIN(number)

The specified number must be between -1 and 1, otherwise this function returns NULL.

Example

In this example, the following data is given in the numbers table:

The ASIN() function is used to calculate the arcsine as output_number:

SELECT id, input_number, ASIN(input_number) AS output_number
FROM numbers;

The output will be:

Note: For the use of this method with SQL databases like MySQL, SQLite, PostgreSQL, or SQL Server, refer to their respective documentation for more details on the ASIN() function implementation and compatibility.