Limiting the Number of Records in SQL in Python

To limit the number of lines output, use the LIMIT command.

Example

Let's select the first two users:

query = "SELECT * FROM users LIMIT 2"

Example

Let's select all users with a salary of 500, and then use LIMIT to take only the first two of those selected:

query = "SELECT * FROM users WHERE salary=500 LIMIT 2"

The result of the executed code:

{'id': 1, 'name': 'user1', 'age': 23, 'salary': 400}
{'id': 2, 'name': 'user2', 'age': 25, 'salary': 500}

Example

With LIMIT you can select multiple rows from the middle of the result. In the example below, we will select from the second row (row numbering starts from zero), 4 pieces:

query = "SELECT * FROM users LIMIT 1,4"

The result of the executed code:

{'id': 2, 'name': 'user2', 'age': 25, 'salary': 500}
{'id': 3, 'name': 'user3', 'age': 23, 'salary': 500}
{'id': 4, 'name': 'user4', 'age': 30, 'salary': 900}
{'id': 5, 'name': 'user5', 'age': 27, 'salary': 500}

Practical tasks

Get the first 4 users.

Get users from the second, 3 pieces.