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.
Taak
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.
Oplossing
9
1
2
3
4
5
SELECT album, singer
FROM songs
WHERE year BETWEEN 1970 and 1981
ORDER BY album
LIMIT 5
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 3. Hoofdstuk 9
9
1
No query executed yet... |
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.