Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Leer SQL Top and Limit | Filtering Statements
SQL Tutorial for Beginners

book
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:

--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
copy

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 albums and their singers, which are sorted by naming, and return the result. Choose only albums from the 1970s.

Oplossing

SELECT album, singer
FROM songs
WHERE year BETWEEN 1970 and 1981
ORDER BY album
LIMIT 5

Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 3. Hoofdstuk 9

Query ResultQuery Result
No query executed yet...

Vraag AI

expand
ChatGPT

Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.

We use cookies to make your experience better!
some-alt