# SQL - SIN() Function

The SQL SIN() function is a mathematical function that retrieves the sine value of a numerical value. It accepts an integer as a parameter as well as angles such as PI()/2, PI()/3, PI()/4, and PI()/6 and returns the float expression which is the the sin value (in radians).

### Syntax

Following is the syntax of the SQL SIN() function −

```SELECT SIN(X) AS alias_name
```

Where x is the numeric value which returns by the SIN() in radians.

Following is the syntax to use the SIN function in a SQL table −

```SELECT SIN(Integer_column_name) AS Alias_Name FROM table_name;
```

We can use the above syntax, to find the sine value of the column of a table.

### Example

In the following example, we are calculating the sine value of the radian 1.

Following is the query −

```SELECT SIN(1) AS sine_value;
```

### Output

On execution of the above SQL query, we get the sine value of the 1.

```+--------------------+
| sine_value         |
+--------------------+
| 0.8414709848078965 |
+--------------------+
```

### Example

In the following example, we can also pass the PI() function to the SIN() function to calculate the value of SIN(PI()) in radians.

Following is the query −

```SELECT SIN(PI()) AS sine_value;
```

### Output

On execution of the above SQL query, we get the value of the SIN(PI()) as follow:

```+------------------------+
| SIN(PI())              |
+------------------------+
| 1.2246467991473532e-16 |
+------------------------+
```

### Example

In the following example, we are calculating the sine value of the null using the SIN() function. Following is the query −

```SELECT SIN(NULL) as sine_of_null;
```

### Output

When we run the above SQL query, we get the null value because if we pass a null value to the sin() function, it will only return the null value.

```+--------------+
| sine_of_null |
+--------------+
|         NULL |
+--------------+
```

### Example

In the following example, we are calculating the sine value of the 0 using the SIN() function.

Following is the query −

```SELECT SIN(0) as sine_of_zero;
```

### Output

When we run the above SQL query, we get the 0 value because if we pass a 0 value to the sin() function, it will only return the 0 value.

```+--------------+
| sine_of_zero |
+--------------+
|            0 |
+--------------+
```

### Example

In the following example, we are fetching the ID, NAME and calculating the sine value of the age using the SIN() function from the customers table.

Let’s create a table named customers using the CREATE statement −

```CREATE TABLE customers(ID INT NOT NULL PRIMARY KEY(ID),
NAME VARCHAR(30) NOT NULL,
AGE INT NOT NULL, ADDRESS CHAR(30),
SALARY DECIMAL(18, 2));```

Let’s insert the data into the CUSTOMERS using the INSERT statement −

```insert INTO customers VALUES(1, 'Ramesh', 32, 'Ahmedabad', 2000);
insert INTO customers VALUES(2, 'Aman' 23, 'Ranchi', 40000);
insert INTO customers VALUES(3, 'kaushik', 23, 'Kota', 2000);
insert INTO customers VALUES(4, 'Chaitali', 25, 'Mumbai', 6500);
insert INTO customers VALUES(5, 'Rakesh', 24, 'Kota', 30000);
insert INTO customers VALUES(6, 'Vivek', 22, 'Ranchi', 35000);
insert INTO customers VALUES(7, 'Akash', 22, 'Ranchi', 50000);
```

Following is the customers table −

```+------+----------+------+-----------+--------+
| ID   | NAME     | AGE  | ADDRESS   | SALARY |
+------+----------+------+-----------+--------+
|    1 | Ramesh   |   32 | Ahmedabad |   2000 |
|    2 | Aman     |   23 | Ranchi    |  40000 |
|    3 | kaushik  |   23 | Kota      |   2000 |
|    4 | chsitali |   25 | Mumbai    |   6500 |
|    5 | Rakesh   |   24 | kota      |  30000 |
|    6 | Vivek    |   22 | Ranchi    |  35000 |
|    7 | Akash    |   22 | Ranchi    |  50000 |
+------+----------+------+-----------+--------+
```

Following is the query to fetch the details −

```SELECT ID, NAME, SIN(AGE) as sine_of_AGE FROM customers;
```

### Output

When we run the above SQL query, we get the following information: ID, NAME, and the sine value of the age −

```+------+----------+-----------------------+
| ID   | NAME     | sine_of_AGE           |
+------+----------+-----------------------+
|    1 | Ramesh   |    0.5514266812416906 |
|    2 | Aman     |   -0.8462204041751706 |
|    3 | kaushik  |   -0.8462204041751706 |
|    4 | Chaitali |  -0.13235175009777303 |
|    5 | Rakesh   |   -0.9055783620066238 |
|    6 | Vivek    | -0.008851309290403876 |
|    7 | Akash    | -0.008851309290403876 |
+------+----------+-----------------------+
```
sql-numeric-functions.htm 