SQL Tutorial SQL Advanced SQL Database SQL References
SQL Tutorial SQL Advanced SQL Database SQL References

SQL Server - TAN() Function

The SQL Server (Transact-SQL) TAN() function returns trigonometric tangent of an angle (angle should be in radians).

Syntax

TAN(x)

Parameters

x Required. Specify the angle in radian.

Return Value

Returns the trigonometric tangent of an angle.

Example 1:

The example below shows the usage of TAN() function.

SELECT TAN(0);
Result: 0

SELECT TAN(1);
Result: 1.5574077246549023

SELECT TAN(-1);
Result: -1.5574077246549023

SELECT TAN(2);
Result: -2.185039863261519

SELECT TAN(-2);
Result: 2.185039863261519

SELECT TAN(PI());
Result: -0.00000000000000012246467991473532

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 1-10
Data 2-5
Data 30
Data 45
Data 510

The statement given below can be used to calculate the trigonometric tangent value of column x.

SELECT *, TAN(x) AS TAN_Value FROM Sample;

This will produce the result as shown below:

DataxTAN_Value
Data 1-10-0.6483608274590866
Data 2-53.380515006246586
Data 300
Data 45-3.380515006246586
Data 5100.6483608274590866

❮ SQL Server Functions
AlphaCodingSkills
AlphaCodingSkills Android App
Facebook Page Twitter Page LinkedIn Page
Learning Tutorials
Learning Tutorials
Useful Links
Python Libraries
About Us  |  Privacy Policy  |  Contact Us
AlphaCodingSkills is a online learning portal that provides tutorials on Python, Java, C++, C, C#, PHP, R, Ruby, Rust, Scala, Swift, Perl, SQL, Data Structures and Algorithms. Tutorials, examples, references and content of the website are reviewed and simplified continuously to improve comprehensibility and eliminate any possible error. We use cookies to ensure best browsing experience on our website. While using this website, you acknowledge to have read and accepted our cookie and privacy policy.