Return the sum of the “Quantity” field in the “OrderDetails” table:
SELECT SUM(Quantity) AS TotalItemsOrdered FROM OrderDetails;
The SUM() function calculates the sum of a set of values.
Note: NULL values are ignored. Continue reading MySQL SUM Function
Return the square root of a number:
SELECT SQRT(64);
The SQRT() function returns the square root of a number. Continue reading MySQL SQRT Function
Return the sine of a number:
SELECT SIN(2);
The SIN() function returns the sine of a number. Continue reading MySQL SIN Function
Return the sign of a number:
SELECT SIGN(255.5);
The SIGN() function returns the sign of a number.
This function will return one of the following:
Round the number to 2 decimal places:
SELECT ROUND(135.375, 2);
The ROUND() function rounds a number to a specified number of decimal places.
Return a random decimal number (no seed value – so it returns a completely random number >= 0 and <1):
SELECT RAND();
The RAND() function returns a random number between 0 (inclusive) and 1 (exclusive). Continue reading MySQL RAND Function
Convert a degree value into radians:
SELECT RADIANS(180);
The RADIANS() function converts a degree value into radians.
Return 4 raised to the second power:
SELECT POWER(4, 2);
The POWER() function returns the value of a number raised to the power of another number.
Return 4 raised to the second power:
SELECT POW(4, 2);
The POW() function returns the value of a number raised to the power of another number.
POW(x, y)
| Parameter | Description |
|---|---|
| x | Required. A number (the base) |
| y | Required. A number (the exponent) |
| Works in: | From MySQL 4.0 |
|---|
Return 8 raised to the third power:
SELECT POW(8, 3);
Return the value of PI:
SELECT PI();
The PI() function returns the value of PI.