Example
Convert a radian value into degrees:
SELECT DEGREES(1.5);
Definition and Usage
The DEGREES() function converts a value in radians to degrees.
Note: See also the RADIANS() and PI() functions.
Syntax
DEGREES(number)
Author: Mostafa
SQL COT Function
Example
Return the cotangent of a number:
SELECT COT(6);
Definition and Usage
The COT() function returns the cotangent of a number.
Syntax
COT(number)
SQL COS Function
Example
Return the cosine of a number:
SELECT COS(2);
Definition and Usage
The COS() function returns the cosine of a number.
Syntax
COS(number)
SQL COUNT Function
Example
Return the number of products in the “Products” table:
SELECT COUNT(ProductID) AS NumberOfProducts FROM Products;
Definition and Usage
The COUNT() function returns the number of records returned by a select query.
Note: NULL values are not counted.
Syntax
COUNT(expression)
SQL CEILING Function
Example
Return the smallest integer value that is greater than or equal to a number:
SELECT CEILING(25.75) AS CeilValue;
Definition and Usage
The CEILING() function returns the smallest integer value that is larger than or equal to a number.
Tip: Also look at the FLOOR() and ROUND() functions.
Syntax
CEILING(number)
SQL AVG Function
Example
Return the average value for the “Price” column in the “Products” table:
SELECT AVG(Price) AS AveragePrice FROM Products;
Definition and Usage
The AVG() function returns the average value of an expression.
Note: NULL values are ignored.
Syntax
AVG(expression)
SQL ATN2 Function
Example
Return the arc tangent of two values:
SELECT ATN2(0.50, 1);
Definition and Usage
The ATN2() function returns the arc tangent of two numbers.
Syntax
ATN2(a, b)
SQL ATAN Function
Example
Return the arc tangent of a number:
SELECT ATAN(2.5);
Definition and Usage
The ATAN() function returns the arc tangent of a number.
Syntax
ATAN(number)
SQL ASIN Function
Example
Return the arc sine of a number:
SELECT ASIN(0.25);
Definition and Usage
The ASIN() function returns the arc sine of a number.
The specified number must be between -1 to 1, otherwise this function returns NULL.
Syntax
ASIN(number)
SQL ACOS Function
Example
Return the arc cosine of a number:
SELECT ACOS(0.25);
Definition and Usage
The ACOS() function returns the arc cosine of a number.
The specified number must be between -1 to 1, otherwise this function returns NULL.
Syntax
ACOS(number)