Tutorial Gateway

Python SQL Select Top

by

In this article, we will show you, How to write a SQL Select Top in the Python Programming language. Or, how to select top 10 records with an example. 

TIP: Please refer Connect Python to SQL Server article to understand the steps involved in establishing a connection.

Before we get into the Python SQL Select Top 10 example, let me show you the data that we are going to use.

Python SQL Select Top Example 1

Python SQL Select Top Example 1

In this example, we will show you, how to use the Top Clause to select first 10 records from a customer sales table. 

# Python SQL TOP Example
import pyodbc
TopConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

TopCursor = TopConn.cursor()
TopCursor.execute("SELECT TOP 10 * FROM CustomerSale ")

for row in TopCursor:
    print('row = %r' % (row,))

OUTPUT

Python SQL Select Top Example 2

ANALYSIS

Below program selects first 10 or top 10 records in a Customer Sales table.

TopCursor.execute("SELECT TOP 10 * FROM CustomerSale ")

Next, we used the For loop to iterate records present in the Top Cursor. Within the For Loop, we used the print statement to print records.

for row in TopCursor:    
    print('row = %r' % (row,))

Python SQL Top Example 2

In this example we are using Order By Clause along with Top Clause. Below program sort data in Descending order using Sales, and then it select first 10 records from the sorted table. 

# Python SQL TOP Example
import pyodbc
TopConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

TopCursor = TopConn.cursor()
TopCursor.execute("SELECT TOP 10 * FROM CustomerSale ORDER BY Sales DESC")

for row in TopCursor:
    print('row = %r' % (row,))

OUTPUT

Python SQL Select Top Example 3

SQL Top in Python Example 3

In this example we are using the Percent to select top 40 percent records from a customer sales table. 

# Python SQL TOP Example
import pyodbc
TopConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

TopCursor = TopConn.cursor()
TopCursor.execute("SELECT TOP 40 PERCENT * FROM CustomerSale ORDER BY Sales DESC")

for row in TopCursor:
    print('row = %r' % (row,))

OUTPUT

Python SQL Select Top Example 4