Python SQLite – LIMIT Clause

0 0 1 minute read

In this article, we are going to discuss the LIMIT clause in SQLite using Python. But first, let’s get a brief about the LIMIT clause.

If there are many tuples satisfying the query conditions, it might be resourceful to view only a handful of them at a time. LIMIT keyword is used to limit the data given by the SELECT statement.

Syntax:

SELECT column1, column2, column n

FROM table_name

LIMIT [no of rows];

where no of rows is an integer value specified as the no of rows to get as output from table.

Let’s create a database.

Python3

# importing sqlite module 
import sqlite3 
  
# create connection to the database  
#zambiatek_database 
connection = sqlite3.connect('zambiatek_database.db') 
  
# create table named address of customers 
# with 4 columns id,name age and address 
connection.execute('''CREATE TABLE customer_address 
         (ID INT PRIMARY KEY     NOT NULL, 
         NAME           TEXT    NOT NULL, 
         AGE            INT     NOT NULL, 
         ADDRESS        CHAR(50)); ''') 
  
# close the connection 
connection.close() 

Output:

Now, Insert 5 records into the customer_address table.

Python3

# importing sqlite module 
import sqlite3 
  
# create connection to the database  
#zambiatek_database 
connection = sqlite3.connect('zambiatek_database.db') 
  
# insert records into table 
connection.execute( 
    "INSERT INTO customer_address VALUES (1, 'nikhil teja', 22, 'hyderabad' )") 
  
connection.execute( 
    "INSERT INTO customer_address VALUES (2, 'karthik', 25, 'khammam')") 
  
connection.execute( 
    "INSERT INTO customer_address VALUES (3, 'sravan', 22, 'ponnur' )") 
  
connection.execute( 
    "INSERT INTO customer_address VALUES (4, 'deepika', 25, 'chebrolu' )") 
  
connection.execute( 
    "INSERT INTO customer_address VALUES (5, 'jyothika', 22, 'noida')") 
  
# close the connection 
connection.close() 

Output:

After adding data let’s perform the limit operation. In this example, we are going to display the top 4 data from the table.

Python3

# importing sqlite module 
import sqlite3 
  
# create connection to the database  
#zambiatek_database 
connection = sqlite3.connect('zambiatek_database.db') 
  
# sql query to display top4 data from table 
cursor = connection.execute("SELECT * FROM customer_address LIMIT 4") 
  
# display data row by row 
for i in cursor: 
    print(i) 
  
# close the connection 
connection.close() 