Python SQLite cursor.fetchmany() Function

The python cursor.fetchmany() function fetches the next rows of a database. This function returns an empty list when there are no rows available. It retrieves to fetch as many rows as are available.

A cursor is an object that is used to interact with the database. This function allows us to execute SQL queries. It returns tuples representing a row. A Cursor is used for executing commands and retrieving query results.

Syntax

Following is the basic syntax for the cursor.fetchmany() function.

cursor.fetchmany(size = cursor.arraysize)

Parameters

The size of the parameter determines the number of rows to retrieve.

Return Value

This function returns a list of tuples; each tuple represents a row from the dataset. If there are less number of rows available then this function will return only the specified rows.

Example

Consider the following EMPLOYEES table which stores employees ID, Name, Age, Salary, City and Country −

Example 1

Consider the above example of fetching the number of rows at a time using cursor.fetchmany() function.

cursor.execute("SELECT * FROM employees")
rows = cursor.fetchmany(size = 2)
for row in rows:
    print(row)

Output

The result is obtained as follows −

Example 2

In the example below, we are going to fetch specified rows with particular columns using cursor.fetchmany() function.

cursor.execute("SELECT Name, City FROM employees)
rows = cursor.fetchmany(size = 3)
for row in rows:
    print(row)

Output

We will get the output as follows −

Example 3

In the below example, we are fetching all columns from the employee table where the country is 'India' using cursor.fetchmany() function.

cursor.execute("SELECT * FROM employees WHERE country = 'India'")
rows = cursor.fetchmany(size = 4)
for row in rows:
    print(row)

Output

The result is generated as follows −