# SQL DEGREES Function

The SQL Server DEGREES function is a Mathematical function used to convert the angle measured in radians to an approximately equivalent angle measured in degrees. The syntax of the DEGREES Function is shown below.

```SELECT DEGREES (Numeric_Expression)
FROM [Source]```

Numeric_Expression: The SQL DEGREES function accepts exact numeric or approximately numeric data types. Remember that this function will not accept Bit data types.

## SQL Server DEGREES Function Example

The SQL DEGREES function is useful to convert user-specified radians to an approximately equivalent angle in degrees. In this example, we will find the degrees of different data values (both positive and negative) and display the output.

```DECLARE @i float
SET @i = 1.20

SELECT DEGREES(@i)AS [Degrees Result 1]

-- Finding Degrees directly
SELECT DEGREES(1) AS [Degrees Result 2]

SELECT DEGREES(PI()) AS [Degrees Result 3]
SELECT DEGREES(PI()/2) AS [Degrees Result 4]
SELECT DEGREES(PI()/3) AS [Degrees Result 5]

SELECT DEGREES(-6.579) AS [Degrees Result 6]
SELECT DEGREES(-4.23) AS [Degrees Result 7]```

Within this example query, we are finding the degrees of radiant @i. We also assigned a new name to the result as ‘Result 1’ using the ALIAS Column in SQL Server.

`SELECT DEGREES(@i)AS [Degrees Result 1]`

In the following three statements, We used the DEGREES function directly on the positive values. Here, DEGREES(PI()) means (3.14)

```SELECT DEGREES(PI()) AS [Degrees Result 3]
SELECT DEGREES(PI()/2) AS [Degrees Result 4]
SELECT DEGREES(PI()/3) AS [Degrees Result 5]```

Next, We used this Mathematical function directly on the negative values.

```SELECT DEGREES(-6.579) AS [Degrees Result 6]
SELECT DEGREES(-4.23) AS [Degrees Result 7]```

## DEGREES Example 2

In this example, we are using this SQL Server degrees function on a Mathematical functions table.

For this demonstration, We are going to convert all the records present in the [Service Grade] column to equivalent degree values using this Function.

```SELECT [EnglishProductName]
,[Color]
,[StandardCost]
,[SalesAmount]
,[TaxAmt]