Python SQLite – LIMIT Clause
Last Updated :
27 Apr, 2021
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
import sqlite3
connection = sqlite3.connect( 'geeks_database.db' )
connection.execute(
)
connection.close()
|
Output:
Now, Insert 5 records into the customer_address table.
Python3
import sqlite3
connection = sqlite3.connect( 'geeks_database.db' )
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')" )
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
import sqlite3
connection = sqlite3.connect( 'geeks_database.db' )
cursor = connection.execute( "SELECT * FROM customer_address LIMIT 4" )
for i in cursor:
print (i)
connection.close()
|
Output:
In this way, we can restrict the rows in the output and print the top N rows by setting the LIMIT as N.
Share your thoughts in the comments
Please Login to comment...