Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære SQL Min and Max | SQL Aggregate Functions
SQL Tutorial for Beginners
Sektion 2. Kapitel 1
single

single

bookSQL Min and Max

Stryg for at vise menuen

Aggregate Functions

There are functions in SQL that returns single line result among a group of the rows. These functions are called aggregate functions.

MIN() and MAX() functions return the minimum and maximum result from the query, and this is always a single line.

Let's find the release date of the oldest song in our table:


              
1

            
SELECT MIN(year) FROM songs
copy

Now, let's select the price of the most expensive song of 21st century:


              
12

            
SELECT MAX(price) FROM songs
WHERE year > 2000
copy
Opgave

Swipe to start coding

Find the price of the most expensive song.

Løsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 2. Kapitel 1
single

single

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

some-alt