SQL Server SIN() Function

Summary: in this tutorial, you will learn how to use the SQL Server SIN() function to calculate the sine of a number.

Introduction to the SQL Server SIN() function

In SQL Server, the SIN() function is a math function that returns the sine of a number.

Here’s the syntax of the SIN() function:

SIN(n)Code language: SQL (Structured Query Language) (sql)

In this syntax:

• n is the angle in radians for which you want to find the sine value.

The SIN() function returns the sine of the argument n. If n is NULL, the SIN() function returns NULL.

SQL Server SIN() function examples

Let’s explore some examples of using the SIN() function.

1) Basic SIN() function example

The following example uses the SIN() function to calculate the sine of the number 1 radian:

SELECT SIN(1) as sine_value;Code language: SQL (Structured Query Language) (sql)

Output:

sine_value
-----------------
0.841470984807897Code language: SQL (Structured Query Language) (sql)

2) Using the SIN() function with PI() function

The following example uses the SIN() function to find the sine of pi/6:

SELECT SIN(PI()/6) sine_value;Code language: SQL (Structured Query Language) (sql)

Output:

sine_value
-----------
0.5Code language: SQL (Structured Query Language) (sql)

3) Using SIN() function with table data

First, create a table called angles to store angles in radians:

CREATE TABLE angles(
    id INT IDENTITY PRIMARY KEY,
    angle DEC(19,2)
);Code language: SQL (Structured Query Language) (sql)

Second, insert some rows into the angles table:

INSERT INTO
  angles (angle)
VALUES
  (1),
  (PI() / 2),
  (PI() / 6);Code language: SQL (Structured Query Language) (sql)

Third, retrieve data from the angles table:

SELECT
  id,
  angle
FROM
  angles;Code language: SQL (Structured Query Language) (sql)

Output:

id | angle
---+-------
1  | 1.00
2  | 1.57
3  | 0.52
(3 rows)Code language: SQL (Structured Query Language) (sql)

Finally, calculate the sines of angles from the angles table:

SELECT
  id,
  SINE (angle) sine_value
FROM
  angles;

Output:

id | sine_value
---+-----------
1  | 0.84
2  | 1.0
3  | 0.5
(3 rows)Code language: SQL (Structured Query Language) (sql)

Summary

• Use the SIN() function to calculate the sine of a number.