Oppiskele Introduction to Numeric Functions

Numeric functions in SQL are essential tools for analyzing and transforming numerical data stored in your tables. You use these functions to round values, perform mathematical calculations, and extract specific numeric information from your data. Whether you are calculating totals, adjusting prices, or preparing data for reports, numeric functions help you get accurate and meaningful results from your queries.


              1234567891011
            
-- Use ROUND to round prices to the nearest whole number
SELECT name, price, ROUND(price) AS rounded_price
FROM products;

-- Use CEILING to always round prices up
SELECT name, price, CEILING(price) AS ceiling_price
FROM products;

-- Use FLOOR to always round prices down
SELECT name, price, FLOOR(price) AS floor_price
FROM products;

You can also use numeric functions like ABS and POWER for more advanced calculations. The ABS function returns the absolute value of a number, which is useful when you need to remove any negative sign from a result. The POWER function raises a number to a specified power, allowing you to calculate exponents or squares of values as needed for your analysis.


              1234567
            
-- Use MOD to find the remainder of stock divided by 10
SELECT name, stock, MOD(stock, 10) AS stock_remainder
FROM products;

-- Use SQRT to calculate the square root of the price
SELECT name, price, SQRT(price) AS price_sqrt
FROM products;

1. Which function rounds a number up to the nearest integer?

2. What does the MOD function return?

3. Fill in the blanks to calculate the square root of the price for each product.

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 3. Luku 1

Kysy tekoälyä

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

Pyyhkäise näyttääksesi valikon