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

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.

This course was created for very beginners in programming, for those who want to start learning such a popular language for work with databases. Nowadays, all the applications and services collect some data and work with it, and basic SQL syntax is a foundation for further work with other Database Management Systems.

Familiarize yourself with database you will work with, and basic syntax to start executing your first queries!

SQL Top and Limit

解答