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;