AppDividend
Latest Code Tutorials

SQL SIN() Function Example | SIN() in SQL

SQL SIN() is an inbuilt function that is used for finding the sine of a specified angle – measured in radians – in the specified expression.

SQL SIN()

SQL SIN() is an inbuilt function that returns the sine of a number. More specifically, this function returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression. The return data type is float.

Syntax

SELECT SIN (Expression);

Parameters

Expression: The Expression whose sine value is to be retrieved.

Return Value

The return data type is float.

Examples

Query 1

SELECT SIN (1);

Output

0.8414709848078965

Explanation

Here, sine value is returned.

Query 2

SELECT SIN (1.52);

Output

0.998710143975583

Explanation

Here, the sine value of a fraction is returned.

Query 3

SELECT SIN (NULL);

Output

NULL

Explanation

Passing of NULL value as an argument will return a NULL value.

Query 4

SELECT SIN (1+1);

Output

0.9092974268256817

Explanation

Here, the sine value of an expression is returned.

Query 5

SELECT SIN (PI ());

Output

1.2246467991473532e-16

Explanation

Here, the sine value of the PI function is calculated which is given as an argument.

See also

SQL SQRT()

SQL TAN()

SQL CEILING()

SQL FLOOR()

SQL POWER()

Leave A Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.