SQL Top and Limit
TOP and LIMIT statements determine the amount of records in the result. For example, you want to limit the result with 7 records. In MS SQL and PostgreSQL, use the LIMIT keyword at the end of the query:
9
1
2
3
4
--Find top-3 the eldest songs
SELECT title, year FROM songs
ORDER BY year
LIMIT 3
1234--Find top-3 the eldest songs SELECT title, year FROM songs ORDER BY year LIMIT 3
In MySQL syntax, use TOP keyword with select
to limit the number of output rows. You can also set a percentage: SELECT TOP 50 PERCENT
.
During this course we will use the LIMIT statement.
Opgave
Swipe to start coding
Find 5 first album
s and their singer
s, which are sorted by naming, and return the result. Choose only albums from the 1970s.
Løsning
9
1
2
3
4
5
SELECT album, singer
FROM songs
WHERE year BETWEEN 1970 and 1981
ORDER BY album
LIMIT 5
Var alt klart?
Tak for dine kommentarer!
Sektion 3. Kapitel 9
single
9
1
No query executed yet... |
Spørg AI
Spørg AI
Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat