Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lernen 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.

Aufgabe

Swipe to start coding

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

Lösung

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

War alles klar?

Wie können wir es verbessern?

Danke für Ihr Feedback!

Abschnitt 3. Kapitel 1

toggle bottom row
Query ResultQuery Result
No query executed yet...
some-alt