The SIN function in SQL is a mathematical function that returns the sine of a given angle, where the angle is provided in radians.

? Syntax

SIN(numeric_expression)

• numeric_expression should be a floating-point number representing an angle in radians.

? Return Value

• Returns a float value between -1 and 1, representing the sine of the input.

• The result is calculated using the standard trigonometric sine function.

? Example Usage

SELECT SIN(0) AS Sin0,              -- Returns 0       SIN(PI()/2) AS Sin90,        -- Returns ~1       SIN(PI()) AS Sin180,         -- Returns ~0       SIN(3 * PI() / 2) AS Sin270; -- Returns ~-1

Note: Use PI() to get the value of ? (approximately 3.14159) in SQL Server or other SQL dialects that support it.

? Use Cases

• Calculations involving trigonometry or geometry.

• Working with waveforms or periodic functions (e.g., signal processing).

• Simulation or game logic in SQL-based systems.

? Degrees to Radians Helper

If your angle is in degrees, convert it to radians first:

SELECT SIN(30 * PI() / 180.0) AS Sin30Degrees;

This will correctly calculate sin(30°) = 0.5.

Let me know if you want to see examples involving real-world use cases like calculating height from an angle or building sine wave datasets!