SQL - Numeric Functions

FLOOR

FLOOR (number);

SELECT FLOOR(SalePrice) AS RoundedSalePrice
FROM Orders;

ABS

SELECT OrderID, Product, ABS(Quantity) as 'Absolute Quantity'
FROM Orders;

MOD

SELECT OrderNumber, MOD(OrderNumber, 7) as result
FROM Orders;

ROUND

SELECT ROUND(125.215, -2);

CEILING

SELECT ProductName, Price, CEILING (Price) AS RoundedUpPrice
FROM Products;