Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lära MINimal and MAXimal values | Aggregating
SQL Basics

book
MINimal and MAXimal values

Now it's time to talk about aggregate functions - functions that calculate some summary stats. Let's start with extremal summary stats - minimum and maximum values.

To find the minimum (or maximum) value in the column use MIN (or MAX) functions followed by column name. For example, we can find out the cheapest car with Automatic transmission.

SELECT MIN(price)
FROM audi_cars
WHERE transmission = 'Automatic'

              
123

            
SELECT MIN(price)
FROM audi_cars
WHERE transmission = 'Automatic'
copy

Please note, that unlike for DISTINCT function you need to use parentheses for MIN and MAX functions.

Uppgift

Swipe to start coding

From the audi_cars table find out the price of the most expensive Diesel car (fueltype column).

Lösning

SELECT MAX(price)
FROM audi_cars
WHERE fueltype = 'Diesel'

Var allt tydligt?

Hur kan vi förbättra det?

Tack för dina kommentarer!

Avsnitt 3. Kapitel 1

Query ResultQuery Result
No query executed yet...

Fråga AI

expand
ChatGPT

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

some-alt