SQL ASIN Function

The SQL Server ASIN is one of the Mathematical functions used to calculate the trigonometry Arc sine for the specified expression. An Arc sine is also called the inverse of a SINE Function. The syntax of the ASIN Function is:

SELECT ASIN (Float_Expression)
FROM [Source]

The ASIN function only accepts float values between -1 and 1. For this demo, we use the Math Table data. Check the SQL SIN function.

SQL ASIN Function Example

The ASIN function calculates the Arc SINE for a given angle. The following query will show multiple ways to use the ASIN function. Please refer to the list of SQL Mathematical functions from our SQL Server tutorial page.

In the following SQL SELECT statement, we used this function to calculate the Arc sine value for the variable @i. It means ASIN(-0.80) and is assigned a new name as ‘Arc Sine’ using the ALIAS column.

DECLARE @i Float
SET @i = -0.80

SELECT ASIN(@i)AS [Arc Sine]

-- Calculating directly
SELECT ASIN(0.27)AS [Arc Sine]

-- Calculating directly
SELECT ASIN(0.25 + 0.55 - 0.77)AS [Arc Sine]

Here, we will calculate the Arcsine value for all the records present in [Service Grade] using the ASIN function. Please refer to the SQL ACOS and SQL ATAN functions from the Mathematical Functions to find the arc cosine and arc tangent values.

SELECT [EnglishProductName]
      ,[Color]
      ,[StandardCost]
      ,[SalesAmount]
      ,[Service Grade] AS Grade
      ,ASIN([Service Grade]) AS [Arc Sine] 
  FROM [Mathemetical Functions]