The SQL ACOS function is one of the SQL Mathematical Function which is used to calculate the trigonometry Arc cosine for the specified expression. Arc-cosine is also called as inverse of a cosine, Please refer SQL COS Function article to understand the Cosine Function.

## SQL ACOS Function Syntax

The basic syntax of the SQL Server ACOS Function is as shown below:

SELECT ACOS (Float_Expression) FROM [Source]

**TIP:** The ACOS function only accepts float values between -1 and 1.

In this article we will show you, How to write ACOS Function in SQL Server with example. For this, We are going to use the below shown data

## SQL ACOS Function Example 1

The SQL Server ACOS Function is used to calculate the Arc cosine for the given angle. The following query will show multiple ways to use ACOS function.

**T-SQL CODE**

DECLARE @i float SET @i = -0.80 SELECT ACOS(@i) AS [Arc Cosine] -- Calculating ACOS directly SELECT ACOS(0.27) AS [Arc Cosine] -- Calculating ACOS directly SELECT ACOS(0.25 + 0.55 - 0.77) AS [Arc Cosine]

**OUTPUT**

**ANALYSIS**

Below lines of code is used to declare float variable and assigning the value.

DECLARE @i float SET @i = -0.80

In the below statement, We used ACOS function to calculate the Arccosine value for the variable @i (It means ACOS(-0.80)). We also assigned new name to that result as ‘Arc Cosine’ using SQL ALIAS Column.

SELECT ACOS(@i) AS [Arc Cosine]

In the next statements, We used the ACOS Function directly on the float values.

## SQL ACOS Function Example 2

In this example, We are going to calculate the Arc cosine value for all the records present in [Service Grade] using ACOS Function.

**T-SQL CODE**

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

**OUTPUT**

Thank You for Visiting Our Blog

## Leave a Reply