SQL - TAN() Function

SQL TAN() is a mathematical function that fetches the tangent of a numerical value as well as an angles value like PI(), PI()/2, PI()/3, PI()/4, and PI()/6, and returns the float expression representing the tangent of the given number in radians.

Syntax

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

```SELECT TAN(X) AS alias_name
```

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

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

We can use the above syntax, which will accept the column name that accepts the integer value, to perform the TAN function to find the tangent value.

Parameters

• x − is the numeric value which returns in radians.

Example

In the following example, we are performing the SQL TAN() function, which will show the tangent of the specified number.

Following is the query −

```SELECT TAN(10) AS tan;
```

Output

When we execute the above query, we get the tangent of the 10.

```+--------------------+
| tan                |
+--------------------+
| 0.6483608274590866 |
+--------------------+
```

Example

In the following example, we are fetching the tangent value of the negative and 0 values as well.

Following is the query −

```SELECT TAN(0) AS tanOfZero, TAN(-16) AS tanOfNegative;
```

Output

Following is the output of the above query, which will displays the tangent of zero and a negative value −

```+-----------+---------------------+
| tanOfZero | tanOfNegative       |
+-----------+---------------------+
|         0 | -0.3006322420239034 |
+-----------+---------------------+
```

Example

In the following example, we are fetching the name and the tangent of the salary of the customer's 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,
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);
```

Let’s display the customers details using the SELECT statement −

```SELECT * FROM customers;
```

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 | Chaitali |   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 name and tangent −

```SELECT NAME, TAN(SALARY) AS tanSalary FROM CUSTOMERS;
```

Output

Following is the output of the above SQL query. It displays the customers’ names and tangent salaries −

```+----------+---------------------+
| NAME     | tanSalary           |
+----------+---------------------+
| Ramesh   |  -2.530998328093341 |
| kaushik  |  -2.530998328093341 |
| Chaitali | 0.04482971803926599 |
| Aman     |  2.9342108240743503 |
| Rakesh   |  1.3457841987739905 |
| Vivek    | -0.5253912236027812 |
| Akash    |  55.928056909865184 |
+----------+---------------------+
```
sql-numeric-functions.htm