SQL ACOS Function

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:

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 2014 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

OUTPUT

ANALYSIS

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

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.

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

OUTPUT

Thank You for Visiting Our Blog